EPMDimensionOverride

[Former Member]

Hi Guys/Gals

I am working with EPM10 trying to do multiple Dimension Overrides on my Time Dimension which is part of my Column Key Range and contains approx 50 members which I need to be dynamic and driven from a member property.  I have accomplished this outside of the Column key range and have the require member per column that I select using the EPMDimensionOverride function.  I have managed to get it working for a some of columns as I found there is a 256 character limitation to the cell that the function exists in.  When I create a second EPMDimensionOverride to cater for the rest of the columns it works fine but then after a refresh extra blank columns are inserted between the time members of the first EPMDimensionOverride. 

How do I stop this from happening???

Thanks

Dev G

[former_member182305]

Hi Dev,

Ok here is a way to do what you are trying, i didn't discover this, it was my mate who im working with.

Forget aboutn the Formula EPM Override.

1. in the Page Axis Write the time and the category exactly as you want to show it (you have to have the member recognition option activated). :

Example:

2010.12     2011.12        2012.12

Actual      Budget          Budget

2. Create a new report once you have this with Time and category in Columns and the Dimension you want to expand in rows.

3. The report will expand the time x and the category y selected from the context right?

4. Here is the trick:  Just one category is displayed since just one category is selected on the context, what you need to do is:

     - Select the first cell for time expantion, click on the "fx "button; you will see the parameters needed for the formula EPMOlapMember.... etc.... what you need to do with the first parameter Unique Name 1 is write: EPMMEMBERDESC( HERE do the reference to the cell in the Page axis, in this cas the cell with 2010.12).

     - Now do the same with the Category.

And vualá, you will have your expansion just as you defined it in the Page Axis.

I hope this solve your problem.

[former_member182305]

If i understood right you whant to change the time dinamicly right? together with other members.

If im right thinking what you are doing the blank columnos are not blank columns, a member is being repeted but not in the title to verify that go to

Options-> Sheet Options -> Formating  -> (Check the options that says repeat Column headers)

Proced to refresh, i think you will see how Headers match with each other and i think this document that Srikanth Gandlur sugested me will help you.

scn.sap.com/docs/DOC-30341

Hope this helps you

Regards

Sebas

[Former Member]

Hi Sebastian

Thank you for your response

I have checked the option for repeat Column Header and after a refresh it still includes the Blank columns.  For some reason the category dimension which is nested with my Time dimension in my column key range has my selected member and a blank member and creates a column key range for me that is basically a cartesian join of the EPMDimensionOverride members for Time with the Category members.

I have also tried Srikanth's method of doing this with no success.

Regards

Dev G