Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.54 KB | None | 0 0
  1. /*
  2. The CALCULATE command controls the aggregation of leaf cells in the cube.
  3. If the CALCULATE command is deleted or modified, the data within the cube is affected.
  4. You should edit this command only if you manually specify how the cube is aggregated.
  5. */
  6. CALCULATE;
  7.  
  8. SCOPE ([Kurz PuL].[Calculated].[Umsatz]);
  9. THIS = AGGREGATE([EinfacheBwaZeile].[Hierarchy].&[U]);
  10. END SCOPE;
  11.  
  12. SCOPE ([Kurz PuL].[Calculated].[Wareneinsatz]);
  13. THIS = AGGREGATE([EinfacheBwaZeile].[Hierarchy].&[W]);
  14. END SCOPE;
  15.  
  16. /* DOES NOT WORK: */
  17. SCOPE ([Kurz PuL].[Calculated].[Rohertrag]);
  18. THIS = AGGREGATE(FILTER([EinfacheBwaZeile].[Hierarchy].CurrentMember, { [EinfacheBwaZeile].[Hierarchy].&[U], [EinfacheBwaZeile].[Hierarchy].&[W] }));
  19. END SCOPE;
  20.  
  21. SCOPE ([Kurz PuL].[Calculated].[Personal]);
  22. THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[P] });
  23. END SCOPE;
  24.  
  25. SCOPE ([Kurz PuL].[Calculated].[Marketing]);
  26. THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[M] });
  27. END SCOPE;
  28.  
  29. /* DOES NOT WORK: */
  30. SCOPE ([Kurz PuL].[Calculated].[Deckungsbeitrag]);
  31. THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[U], [EinfacheBwaZeile].[Hierarchy].&[W], [EinfacheBwaZeile].[Hierarchy].&[R], [EinfacheBwaZeile].[Hierarchy].&[P]
  32. , [EinfacheBwaZeile].[Hierarchy].&[M], [EinfacheBwaZeile].[Hierarchy].&[D] });
  33. END SCOPE;
  34.  
  35. SCOPE ([Kurz PuL].[Calculated].[SbA]);
  36. THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[S] });
  37. END SCOPE;
  38.  
  39. /* DOES NOT WORK: */
  40. SCOPE ([Kurz PuL].[Calculated].[EBITDA]);
  41. THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[U], [EinfacheBwaZeile].[Hierarchy].&[W], [EinfacheBwaZeile].[Hierarchy].&[R], [EinfacheBwaZeile].[Hierarchy].&[P]
  42. , [EinfacheBwaZeile].[Hierarchy].&[M], [EinfacheBwaZeile].[Hierarchy].&[D]
  43. , [EinfacheBwaZeile].[Hierarchy].&[S], [EinfacheBwaZeile].[Hierarchy].&[A] });
  44. END SCOPE;
  45.  
  46. /* DOES NOT WORK: */
  47. SCOPE ([Kurz PuL].[Calculated].[EBIT]);
  48. THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[U], [EinfacheBwaZeile].[Hierarchy].&[W], [EinfacheBwaZeile].[Hierarchy].&[R], [EinfacheBwaZeile].[Hierarchy].&[P]
  49. , [EinfacheBwaZeile].[Hierarchy].&[M], [EinfacheBwaZeile].[Hierarchy].&[D]
  50. , [EinfacheBwaZeile].[Hierarchy].&[S], [EinfacheBwaZeile].[Hierarchy].&[A]
  51. , [EinfacheBwaZeile].[Hierarchy].&[I] });
  52. END SCOPE;
  53.  
  54. /* DOES NOT WORK: */
  55. SCOPE ([Kurz PuL].[Calculated].[EBT]);
  56. THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[U], [EinfacheBwaZeile].[Hierarchy].&[W], [EinfacheBwaZeile].[Hierarchy].&[R], [EinfacheBwaZeile].[Hierarchy].&[P]
  57. , [EinfacheBwaZeile].[Hierarchy].&[M], [EinfacheBwaZeile].[Hierarchy].&[D]
  58. , [EinfacheBwaZeile].[Hierarchy].&[S], [EinfacheBwaZeile].[Hierarchy].&[A]
  59. , [EinfacheBwaZeile].[Hierarchy].&[I]
  60. , [EinfacheBwaZeile].[Hierarchy].&[T] });
  61. END SCOPE;
  62.  
  63. /* DOES NOT WORK: */
  64. SCOPE ([Kurz PuL].[Calculated].[Periodenergebnis]);
  65. THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[U], [EinfacheBwaZeile].[Hierarchy].&[W], [EinfacheBwaZeile].[Hierarchy].&[R], [EinfacheBwaZeile].[Hierarchy].&[P]
  66. , [EinfacheBwaZeile].[Hierarchy].&[M], [EinfacheBwaZeile].[Hierarchy].&[D]
  67. , [EinfacheBwaZeile].[Hierarchy].&[S], [EinfacheBwaZeile].[Hierarchy].&[A]
  68. , [EinfacheBwaZeile].[Hierarchy].&[I]
  69. , [EinfacheBwaZeile].[Hierarchy].&[T]
  70. , [EinfacheBwaZeile].[Hierarchy].&[E] });
  71. END SCOPE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement