How to set MUN default value in DMR reports

[inu]

Hi Team,

I created query calculation instead of slicer or detail filter.
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].['+prompt('PLine','token','ALL')+']'#

I used both heirarchy and level.

this kpi contains (ALL, GL, IL), i used item([Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key],1) in place of ALL. still getting error : RSVP-VAL-0010 Failed to load the report specification. XQE-PLN-0113 invalid member unique name'[PC].[@MEMBER].[ALL]'.

please guys suggest me in this regard.



Regards,
Inam

[inu]

Hi Team,

I created query calculation instead of slicer or detail filter.
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].['+prompt('PLine','token','ALL')+']'#

I used both heirarchy and level.

this kpi contains (ALL, GL, IL), i used item([Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key],1) in place of ALL. still getting error : RSVP-VAL-0010 Failed to load the report specification. XQE-PLN-0113 invalid member unique name'[PC].[@MEMBER].[ALL]'.

please guys suggest me in this regard.

Hi MF.

I am getting error
I created query calculation instead of slicer or detail filter.
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].['+prompt('par_ProductType','token','ALL')+']'#

I used both heirarchy and level.

this kpi contains (ALL, GL, IL), i used item([Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key],1) in place of ALL. still getting error : RSVP-VAL-0010 Failed to load the report specification. XQE-PLN-0113 invalid member unique name'[PC].[@MEMBER].[ALL]'.


Please help MF.
I need your help. I am about to finish the dashboard and got stuck into this simple thing.

[MFGF]

Hi Team,

I created query calculation instead of slicer or detail filter.
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].['+prompt('PLine','token','ALL')+']'#

I used both heirarchy and level.

this kpi contains (ALL, GL, IL), i used item([Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key],1) in place of ALL. still getting error : RSVP-VAL-0010 Failed to load the report specification. XQE-PLN-0113 invalid member unique name'[PC].[@MEMBER].[ALL]'.

please guys suggest me in this regard.



Regards,
Inam

Are you using a package based on a PowerCube, or is it a DMR package?

What is the MUN of the ALL member?

MF.

[inu]

Are you using a package based on a PowerCube, or is it a DMR package?

What is the MUN of the ALL member?

MF.

Yes, its DMR package.
Member Unique Name : [Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->[all].[-1]
I right clicked on all value under member folder and got above MUN.
this column has three values (ALL, GL, IL) i want to set 'ALL'  as default value.

Please see the attached image.


Inam.

[MFGF]

Yes, its DMR package.
Member Unique Name : [Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->[all].[-1]

That's a good start. It raises an important question, though. Why, in your original expression above, have you set your default MUN to be
[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].[ALL]

This looks like a MUN from a PowerCube (which triggered my initial question). Can you explain your thinking in defining your expression to return a MUN that doesn't match any of your DMR MUNs?

I right clicked on all value under member folder and got above MUN.
this column has three values (ALL, GL, IL) i want to set 'ALL'  as default value.

Please see the attached image.


Inam.

That's the hardest thing you have to do. Now all you need to do is to adjust your original expression to return the MUN you got from your ALL member properties - which should be easy.

MF.

[inu]

That's a good start. It raises an important question, though. Why, in your original expression above, have you set your default MUN to be
[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].[ALL]

This looks like a MUN from a PowerCube (which triggered my initial question). Can you explain your thinking in defining your expression to return a MUN that doesn't match any of your DMR MUNs?

That's the hardest thing you have to do. Now all you need to do is to adjust your original expression to return the MUN you got from your ALL member properties - which should be easy.

MF.

Thanks MF.
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key]->:[PC].[@MEMBER].['+prompt('par_ProductType','token','Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].[ALL')+']'#

I used above statement inplace of default value of the expression in  query calculation as you suggested, but getting syntax error. In left side of arrow symbol i used hierarchy, and for default value i used level.
error because, namespace is repeating in right side of expression.

error:  V5 syntax error found for data item 'Data Item1' of query 'Query_Bubble_Region_monthly', invalid token "->" found after "[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key]->:[PC].[@MEMBER].[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]".
.

then i modified the expression as below
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key]->:[PC].[@MEMBER].['+prompt('par_ProductType','token','ALL')+']'#

Still i got error
error: XQE-PLN-0113 
      Invalid Member Unique Name '[PC].[@MEMBER].[ALL]'

Please correct my understanding and above statement.


Inam.

[inu]

Thanks MF.
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key]->:[PC].[@MEMBER].['+prompt('par_ProductType','token','Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].[ALL')+']'#

I used above statement inplace of default value of the expression in  query calculation as you suggested, but getting syntax error. In left side of arrow symbol i used hierarchy, and for default value i used level.
error because, namespace is repeating in right side of expression.

error:  V5 syntax error found for data item 'Data Item1' of query 'Query_Bubble_Region_monthly', invalid token "->" found after "[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key]->:[PC].[@MEMBER].[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]".
.

then i modified the expression as below
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key]->:[PC].[@MEMBER].['+prompt('par_ProductType','token','ALL')+']'#

Still i got error
error: XQE-PLN-0113 
      Invalid Member Unique Name '[PC].[@MEMBER].[ALL]'

Please correct my understanding and above statement.


Inam.

Hi MF.
finally i used the statement
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].['+prompt('par_ProductType','token','all].[-1')+']'#
it worked.
I am too happy.
But the issue is , i am not using this query item into report, value should display after applying this filter.
what should i do now.

Please suggest.

[inu]

Hi MF.
finally i used the statement
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].['+prompt('par_ProductType','token','all].[-1')+']'#
it worked.
I am too happy.
But one thing i would like to tell you that when i enter any value like ALL, GL, IL. no data available displays, i understand the reason, because of only parameter (par_ProductType), which should be converted into something. you can understand better, i hope.

another issue is , i am not using this query item into report, i have dought that value displays after applying this filter. its not being applied to the report.
what should i do now.

Please suggest.

[inu]

But one thing i would like to tell you that when i enter any value like ALL, GL, IL. no data available displays, i understand the reason, because of only parameter (par_ProductType), which should be converted into something. you can understand better, i hope.

This part is resolved , i used static choice and set use value as (all].[-1 for display value ALL, all].[1 for display value GL, all].[2 for display value IL  )

I am thinking about second part, can i pull that query calculation into slicer. but that will be required prompt which i dont want.

Please suggest

[MFGF]

Thanks MF.
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key]->:[PC].[@MEMBER].['+prompt('par_ProductType','token','Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].[ALL')+']'#

I used above statement inplace of default value of the expression in  query calculation as you suggested, but getting syntax error. In left side of arrow symbol i used hierarchy, and for default value i used level.
error because, namespace is repeating in right side of expression.

error:  V5 syntax error found for data item 'Data Item1' of query 'Query_Bubble_Region_monthly', invalid token "->" found after "[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key]->:[PC].[@MEMBER].[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]".
.

then i modified the expression as below
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key]->:[PC].[@MEMBER].['+prompt('par_ProductType','token','ALL')+']'#

Still i got error
error: XQE-PLN-0113 
      Invalid Member Unique Name '[PC].[@MEMBER].[ALL]'

Please correct my understanding and above statement.


Inam.

What are you doing? Your MUNs don't have [PC].[@MEMBER] anywhere in them, according to what you posted? I don't understand why you are trying to build a MUN that doesn't exist in your data? You told us:

Yes, its DMR package.
Member Unique Name : [Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->[all].[-1]
I right clicked on all value under member folder and got above MUN.

Can you tell me where in that MUN you see ->:[PC].[@MEMBER]. ?

Nope? Me neither. Why, then, are you coding an expression that returns a MUN that has ->:[PC].[@MEMBER]. in it? I'm utterly baffled by your logic.

MF.

[inu]

What are you doing? Your MUNs don't have [PC].[@MEMBER] anywhere in them, according to what you posted? I don't understand why you are trying to build a MUN that doesn't exist in your data? You told us:

Yes, its DMR package.
Member Unique Name : [Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->[all].[-1]
I right clicked on all value under member folder and got above MUN.

Can you tell me where in that MUN you see ->:[PC].[@MEMBER]. ?

Nope? Me neither. Why, then, are you coding an expression that returns a MUN that has ->:[PC].[@MEMBER]. in it? I'm utterly baffled by your logic.

MF.

thanx MF.
You didnot read below quote, which i added that this issue is fixed.
I used  as below

finally i used the statement
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].['+prompt('par_ProductType','token','all].[-1')+']'#
it worked.

[MFGF]

thanx MF.
You didnot read below quote, which i added that this issue is fixed.
I used  as below

finally i used the statement
#'[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].['+prompt('par_ProductType','token','all].[-1')+']'#
it worked.

Look at the MUN your expression built. If you substitute the default, it ends up as:

[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].[all].[-1]

Now compare this with the MUN you told us exists in your DMR package:

[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->[all].[-1]

They are different. The first MUN above is specifically for a PowerCube, and won't work with a DMR source. Please confirm once again what your package is based on - is it DMR or is it a PowerCube? You are giving us conflicting information, and it is making it impossible to follow what you are doing and why.

MF.

[inu]

Look at the MUN your expression built. If you substitute the default, it ends up as:

[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->:[PC].[@MEMBER].[all].[-1]

Now compare this with the MUN you told us exists in your DMR package:

[Fact KPI Summary Monthly (Analysis)].[Product Type].[Product Type Key].[Product Type Key]->[all].[-1]

They are different. The first MUN above is specifically for a PowerCube, and won't work with a DMR source. Please confirm once again what your package is based on - is it DMR or is it a PowerCube? You are giving us conflicting information, and it is making it impossible to follow what you are doing and why.

MF.

I am pretty sure, that i am using dmr model with DQM mode.



Thanx.
Inam

[MFGF]

I am pretty sure, that i am using dmr model with DQM mode.



Thanx.
Inam

So why are you building a MUN that conforms to a PowerCube layout rather than a DMR layout? I'm utterly baffled why you would follow this approach? Can you explain? How can a PowerCube MUN work if you are using DMR? You said the MUN with [PC].[@MEMBER] in it worked? How can it if you are using DMR? It makes no sense at all, and you need to check to make sure what your source is before we can resolve anything...

MF.