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
Quote from: tequila on 10 Aug 2015 07:33:17 AM
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.
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]
Quote from: tequila on 10 Aug 2015 10:04:59 AM
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.