How to wrte the MDX language in 'Edit Column Formual' in Answer, like below express in Logic Layer in BMM:
EVALUATE_AGGR('MAX( %1.members,[Is_Close])', "Sales Cube"."Sales".""."Sales"."Gen5,Time" )
EVALUATE_AGGR('MAX( Time.currentmember.siblings,%1)', "Sales Cube"."Sales".""."Sales"."Is_Close" )
Create a new logical column in the business model holding your Essbase data and edit the Logical Table Source expression list to reference that exact function you mentioned. It should work exactly as you mentioned.
Please assign points if helpful/correct.
Hi JaiG ,
I have done it, but is it possible to write MDX in Answer? I also look at the 'EVALUATE_AGGR' function in 'Edit Column Formual'.
The reason I want to do is that some column is dynamical calculation.
I want to Count Store for Sales,so in ESSBASE it has one flag column,if one store has sales in one day, it will be '1', else '0'.
However, it sum the flag column in ESSBASE Or logical layer in OBIEE for MDX, it will generate wrong result when I select several days.
The expected result is that I want to calculate MAX store count in several days, not sum. How to write MDX? Thanks.
The current case is as below:
I select one day , it will be correct result, such as 1600 stores.
If I select one more days, it will be sum stores in these days, not MAX. such as 4700 stores(3 days).
Hi JaiG ,
Thanks for your reply.
How to write the MDX in 'Edit Column Formual' in Answer?
When I write the following code. it will generate error message:
EVALUATE_AGGR('MAX( Time.currentmember.siblings,%1)', "Sales Cube"."Sales"."Is_Close" )
Are there any missing steps?