Time in both page and column axis

[Former Member]

Hi all,

I have a report with Time dimension (Displays Jan - Dec) in columns and Products in rows. The requirement is, user needs to select a year as part of selection (Page axis), the months of that year needs to be populated in columns. How can I achieve this as we cant use Time dimension in both page and column axis.

-- Selva

[former_member190501 · Accepted solution]

Hi,

You can not keep one dimension in more than one axis. To meet your requirement you can keep Time in column axis and use =EPMContextMember(,"Time") (You can filter based on property to just show only YYYY.TOTAL in selection window) in any of the cells above the reporting area. So that user can select Time by double clicking in this cell.

In column axis you can select Time as Context with relation ship as Base level.

Hope it helps...

regards,

Raju

[Former Member · Accepted solution]

Hi Prasad,

It Worked. Thanks.

But, using EPMContextMember we can select only one value. How about selecting multiple values?

-- Selva

[former_member190501 · Accepted solution]

Hi,

Yes! using EPMContextMember you can select one value. How is your Time hier maintained. Normally it maintained as follows :

2013.TOTAL

-->Q1

   --2013.JAN

If your structure is as above then user should select 2013.TOTAL. In report editor maintain Time from Member selector window as follows :

Other option is if your report columns are always fixed to 12 months based on user selection Year then write simple Excel functions to make report static in columns.

Please check EPM Academy for further assistance on how to create EPM10 reports (videos).

Hope it helps...

regards,

Raju

[arun_varghese]

Hi Selvakumar,

This can be achieved in the following way :

Use a cell, say D1, with the formula =EPMContextMember(,"Time"). This cell can be used as a selection for the user.

Now, assuming you have defined your Time dimension in Column Axis, use the below formula in a random cell.

=EPMDimensionOverride("000";"TIME";"BAS(cell_ref)")

where 'cell_ref ' will be containing the cell which has the =EPMContextMember(,"Time") formula with the YEAR selected.