Dimension Override Functionality

[Former Member]

    Hello Every one,

I am currently using Dimension Override functionality, when user select a base member and selects member and Children or Member and Descendants its not displaying the data, even we have data for that member.

we have two models those are Model A and Model B. For Model A its working fine but Model B its not at all working as described above.

Please find the screen shots here for reference.

Following image is success case:

The failure case.

Dimension Override Formula which we are using:

=IF($F$20="Member & Descendants","LDEP(20,"&$E$20&"),"&$E$20,IF($F$20="Member & Children","DEP("&$E$20&"),"&$E$20,IF($F$20="Basemember","BAS("&$E$20&")",IF($F$20="Member Only",$E$20))))

Appreciate you help.

Thank you very much

regards,

Mallikarjun

[former_member186338]

Sorry, but:

"we have two models those are Model A and Model B. For Model A its working fine but Model B its not at all working as described above." - you did not show any issue for Model B! Absolutely not clear!

And I recommend you to simplify formula and check it!

By the way, there is no EPMDimensionOverride in this formula

Vadim

[Former Member]

Hello Vadim,

Thank you very much for you prompt reply. lets consider in this way we have two models Cost centre and another one is profit centre (for understanding purpose)

The Layouts which we built on cost centre with same dimension override functionality its working fine but not in Profit centre model.

we use the same formula, everything is same.

=EPMDimensionOverride("000","COST_CENTER",E3)

E3 refers the above formula.

Thank you very much...

[former_member186338]

Sorry, but I can't see what are you doing!

"its working fine but not in Profit centre model" - What do you mean by not working??

What is the result of the not working formula???

Do you understand how to test Excel formulas?

Vadim

P.S. On the second screenshot I see missing Excel combobox....

[Former Member]

Hello Vadim,

when user select member only the result is like below. its displaying data. and the select member is a base member in Cost Centre dimension.

when user select like below.

the same base member from cost center dimension, but in the drop down he is selecting Member and children. nothing is change expect the base member to Member and children.

I need to see the data same like figure-1 but its not retrieving the data.

we have this dimension override functionality in each layout in different models(cost center and profit centers ). For cost centers its working like as expected described above. but in profit center model its not working as I expected decribed above.

Yes I know how to test the excel formulas, its not about excel formula its about dimension override function.

hope you will understand now, if not let me know wil try to explain.

Thank you very much

[former_member186338]

"I need to see the data same like figure-1 but its not retrieving the data."

1. I don't see any data retrieval

2. I don't see formulas and results of calculations.

How I can help you???

Vadim

P.S. In the second screenshot I even don't see any word like PROFIT Center!

[Former Member]

Hello Vadim,

I simplifying my problem with one mock example.

if I select a parent member from context and in the drop down selected member and descendants

I am getting the following result. i have data on a base member its showing on report.

if I select a base member the result I am expecting to see above data, but I am not able to see the data on base member.

I checked in the edit report options whether Dimension override is working or not its working fine.

please find the attached screen as reference.

in the layout its not showing data.. this is my problem.

excel formula which I used : =IF($H$8="Member & Descandants","LDEP(20,"&$G$8&"),"&$G$8,"") (which i worte in H7 cell)

dimension override : =EPMDimensionOverride("000","COST_CENTER",H7)

hope you will understand ... Do you have any idea regarding this.

Thank you very much...

[former_member186338]

OK, we are not talking about Profit Center.

And EPMDimensionOverride is working correctly. Override of Row or Column axis happens.

But "in the layout its not showing data.. this is my problem."

Why do you think that no data is related to EPMDimensionOverride?

Simply select manually member and descendants and test! Manually select base member and test!

Show screenshots!

Vadim

[Former Member]

Hello Vadim,

Why do you think that no data is related to EPMDimensionOverride?

          I am not sure whether its related to Dimension override or not. not able to find the exact root cause.

when I select only base member the data is displaying in layout, please find the screen here below as ref.

Thank you very much..

[former_member186338]

"Simply select manually member and descendants and test! Manually select base member and test!"

Test without EPMDimensionOverride!

Vadim

[former_member186338]

P.S. And please provide your BW and BPC and EPM versions and SP!

[Former Member]

Hello Vadim,

Its working fine without dimension override.

Thank you very much..

[former_member186338]

Then it will work the same WITH EPMDimensionOverride - this function has no effect on data retrieve!

Vadim

[Former Member]

Hello Vadim,

please find the detials below.

EPM add-in

Currently using MS-Office 13

Thank you very much ...

[Former Member]

I think you have the right approach using a two step, but without specific cells I'll just relate it in context:

If your selected "COST_CENTER" dimension member was "CC_GROUP"

your override strings should be as follows for the various members:

Member only:                     CC_GROUP

Member and Descendants CC_GROUP,ALL(CC_GROUP)

Member and Children          CC_GROUP,DEP(CC_GROUP)

Children                              DEP(CC_GROUP)

Assuming this is for the default report the override formula should be:

=EPMDimensionOverride("000","COST_CENTER","Overide string")

[Former Member]

Hello Ryan,

What is the difference between these two

Member only:                     CC_GROUP

Member and Descendants CC_GROUP,ALL(CC_GROUP)

Member and Children          CC_GROUP,DEP(CC_GROUP)

Children                              DEP(CC_GROUP)

Member only:                     CC_GROUP

Member and Descendants ALL(CC_GROUP),CC_GROUP

Member and Children         DEP(CC_GROUP),CC_GROUP

Children                              DEP(CC_GROUP)

one is parent after and another is parent before. Parent After is working but Parent before is not working any more. what is the reason.

The reason I need to write formula Parent before is I need to see the total always below the members. if I implement your way its showing total first and base members next.

I want let you know one thing here its working for another layouts except one layout. and in this layout its working as you suggested but not working in my way, which i implemented for other layouts

Please let me know the reason.why its behaving little strange

Thank you very much ..

Mallikarjun

[Former Member]

I'm not sure why one way would work and one wouldn't. Quick question, do you have it actively filtering?  Try turning that off.  Excludes as well to see if you can get proper behavior without filters or excludes in the report query.

Otherwise I think you're doing everything right.

[former_member186338]

"one is parent after and another is parent before. Parent After is working but Parent before is not working any more. what is the reason.

The reason I need to write formula Parent before is I need to see the total always below the members. if I implement your way its showing total first and base members next." - unable to understand where is the issue! What is not working?

Please, always provide meaningful screenshots to illustrate the issue...

Vadim