Skip to Content
author's profile photo Former Member
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???


Dev G

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Aug 01, 2012 at 02:12 PM

    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 Not Active Contributor Srikanth Gandlur sugested me will help you.

    Hope this helps you



    Add a comment
    10|10000 characters needed characters exceeded

    • 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.


      Dev G

  • Posted on Aug 02, 2012 at 03:09 PM

    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). :


    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.