Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- The CALCULATE command controls the aggregation of leaf cells in the cube.
- If the CALCULATE command is deleted or modified, the data within the cube is affected.
- You should edit this command only if you manually specify how the cube is aggregated.
- */
- CALCULATE;
- SCOPE ([Kurz PuL].[Calculated].[Umsatz]);
- THIS = AGGREGATE([EinfacheBwaZeile].[Hierarchy].&[U]);
- END SCOPE;
- SCOPE ([Kurz PuL].[Calculated].[Wareneinsatz]);
- THIS = AGGREGATE([EinfacheBwaZeile].[Hierarchy].&[W]);
- END SCOPE;
- /* DOES NOT WORK: */
- SCOPE ([Kurz PuL].[Calculated].[Rohertrag]);
- THIS = AGGREGATE(FILTER([EinfacheBwaZeile].[Hierarchy].CurrentMember, { [EinfacheBwaZeile].[Hierarchy].&[U], [EinfacheBwaZeile].[Hierarchy].&[W] }));
- END SCOPE;
- SCOPE ([Kurz PuL].[Calculated].[Personal]);
- THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[P] });
- END SCOPE;
- SCOPE ([Kurz PuL].[Calculated].[Marketing]);
- THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[M] });
- END SCOPE;
- /* DOES NOT WORK: */
- SCOPE ([Kurz PuL].[Calculated].[Deckungsbeitrag]);
- THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[U], [EinfacheBwaZeile].[Hierarchy].&[W], [EinfacheBwaZeile].[Hierarchy].&[R], [EinfacheBwaZeile].[Hierarchy].&[P]
- , [EinfacheBwaZeile].[Hierarchy].&[M], [EinfacheBwaZeile].[Hierarchy].&[D] });
- END SCOPE;
- SCOPE ([Kurz PuL].[Calculated].[SbA]);
- THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[S] });
- END SCOPE;
- /* DOES NOT WORK: */
- SCOPE ([Kurz PuL].[Calculated].[EBITDA]);
- THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[U], [EinfacheBwaZeile].[Hierarchy].&[W], [EinfacheBwaZeile].[Hierarchy].&[R], [EinfacheBwaZeile].[Hierarchy].&[P]
- , [EinfacheBwaZeile].[Hierarchy].&[M], [EinfacheBwaZeile].[Hierarchy].&[D]
- , [EinfacheBwaZeile].[Hierarchy].&[S], [EinfacheBwaZeile].[Hierarchy].&[A] });
- END SCOPE;
- /* DOES NOT WORK: */
- SCOPE ([Kurz PuL].[Calculated].[EBIT]);
- THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[U], [EinfacheBwaZeile].[Hierarchy].&[W], [EinfacheBwaZeile].[Hierarchy].&[R], [EinfacheBwaZeile].[Hierarchy].&[P]
- , [EinfacheBwaZeile].[Hierarchy].&[M], [EinfacheBwaZeile].[Hierarchy].&[D]
- , [EinfacheBwaZeile].[Hierarchy].&[S], [EinfacheBwaZeile].[Hierarchy].&[A]
- , [EinfacheBwaZeile].[Hierarchy].&[I] });
- END SCOPE;
- /* DOES NOT WORK: */
- SCOPE ([Kurz PuL].[Calculated].[EBT]);
- THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[U], [EinfacheBwaZeile].[Hierarchy].&[W], [EinfacheBwaZeile].[Hierarchy].&[R], [EinfacheBwaZeile].[Hierarchy].&[P]
- , [EinfacheBwaZeile].[Hierarchy].&[M], [EinfacheBwaZeile].[Hierarchy].&[D]
- , [EinfacheBwaZeile].[Hierarchy].&[S], [EinfacheBwaZeile].[Hierarchy].&[A]
- , [EinfacheBwaZeile].[Hierarchy].&[I]
- , [EinfacheBwaZeile].[Hierarchy].&[T] });
- END SCOPE;
- /* DOES NOT WORK: */
- SCOPE ([Kurz PuL].[Calculated].[Periodenergebnis]);
- THIS = AGGREGATE( { [EinfacheBwaZeile].[Hierarchy].&[U], [EinfacheBwaZeile].[Hierarchy].&[W], [EinfacheBwaZeile].[Hierarchy].&[R], [EinfacheBwaZeile].[Hierarchy].&[P]
- , [EinfacheBwaZeile].[Hierarchy].&[M], [EinfacheBwaZeile].[Hierarchy].&[D]
- , [EinfacheBwaZeile].[Hierarchy].&[S], [EinfacheBwaZeile].[Hierarchy].&[A]
- , [EinfacheBwaZeile].[Hierarchy].&[I]
- , [EinfacheBwaZeile].[Hierarchy].&[T]
- , [EinfacheBwaZeile].[Hierarchy].&[E] });
- END SCOPE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement