cumulate month to last month; current month

[tequila]

hello,

i have simply ecxel report  with column "cumulate month to last month" and column "current month".

Detail filter "[FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit].[Monat].[Monat Num]<9"

I try  - extract(month;current_day) and total(currentMeasure within set periodsToDate.... but it dont work.


can anyone help me?

I use dimensional OLAP package.

measure           cumulate months (1-7)   I   current month ( 8 )
--------------------------------------------------------------------
Berlin      I                                            I
London    I                                            I
Paris       I                                            I
etc...       I                                            I


thank

[MFGF]

hello,

i have simply ecxel report  with column "cumulate month to last month" and column "current month".

Detail filter "[FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit].[Monat].[Monat Num]<9"

I try  - extract(month;current_day) and total(currentMeasure within set periodsToDate.... but it dont work.


can anyone help me?

I use dimensional OLAP package.

measure           cumulate months (1-7)   I   current month ( 8 )
--------------------------------------------------------------------
Berlin      I                                            I
London    I                                            I
Paris       I                                            I
etc...       I                                            I


thank

Hi,

Firstly, don't use detail filters with dimensional packages. It's a practice that can lead to lots of pain and anguish and bizarre results.

The trick here is to construct the MUN (Member Unique Name) of the current month member using an expression - usually a macro. To do this, we need to know what the MUNs of your Month members look like, though. Can you right-click on a Month member in the package tree, choose "Properties" and find the Member Unique Name property, then post it into the thread?

MF.

[tequila]

Hi MFGF,
here is my month MUN


Juli 2015
Pfad [FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit].[Monat]->:[RO].[Zeit (Ist & Plan)].[Zeit].[Alle].[2015].[20153].[201507]
Referenz [FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit].[Monat]->:[RO].[Zeit (Ist & Plan)].[Zeit].[Alle].[2015].[20153].[201507]
Mitgliedstitelzeile Juli 2015
Eindeutiger Mitgliedsname [FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit].[Monat]->:[RO].[Zeit (Ist & Plan)].[Zeit].[Alle].[2015].[20153].[201507]
Eindeutiger Ebenenname [FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit].[Monat]
Eindeutiger Hierarchiename [FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit]
Eindeutiger Dimensionsname [FiBu (OLAP)].[Zeit (Ist & Plan)]
Ebenennummer 3
Eindeutiger übergeordneter Name [FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit].[Quartal]->:[RO].[Zeit (Ist & Plan)].[Zeit].[Alle].[2015].[20153]

[MFGF]

Hi MFGF,
here is my month MUN


Juli 2015
Pfad [FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit].[Monat]->:[RO].[Zeit (Ist & Plan)].[Zeit].[Alle].[2015].[20153].[201507]
Referenz [FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit].[Monat]->:[RO].[Zeit (Ist & Plan)].[Zeit].[Alle].[2015].[20153].[201507]
Mitgliedstitelzeile Juli 2015
Eindeutiger Mitgliedsname [FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit].[Monat]->:[RO].[Zeit (Ist & Plan)].[Zeit].[Alle].[2015].[20153].[201507]
Eindeutiger Ebenenname [FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit].[Monat]
Eindeutiger Hierarchiename [FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit]
Eindeutiger Dimensionsname [FiBu (OLAP)].[Zeit (Ist & Plan)]
Ebenennummer 3
Eindeutiger übergeordneter Name [FiBu (OLAP)].[Zeit (Ist & Plan)].[Zeit].[Quartal]->:[RO].[Zeit (Ist & Plan)].[Zeit].[Alle].[2015].[20153]

Hmmm. Deja vu. Didn't we already solve this problem?

http://www.cognoise.com/index.php/topic,28266.msg90836.html#msg90836

MF.