EPM template reading from olap member

[Former Member]

Hi Experts,

I'm designing a report but it is not reading the values for example:

TIME	2015.Q3	J21
CATEGORY	Actual, Actual_1	J22
AUDITTRAIL	BW	J23
MEASURE	YTD	J24

It is only reading data for the Actual and not Actual_1

= EPMOlapMemberO(J22,"[CATEGORY].[].[ACTUAL]","Actual - Actual","","000")

How can I take also Actual_1

this is for report perspective.

Thanks

regards,

[former_member186338]

Ups, not clear!

Do you want to combine 2 members using page axis? Then you have to allow multimember selection and the formula will be multimember...

Vadim

[former_member186338]

P.S. Sample of multimember formula in page axis:

=EPMOlapMultiMember("1110,1111,1117,1292","000","[TITLES].[PARENTH1].[1110]","[TITLES].[PARENTH1].[1111]","[TITLES].[PARENTH1].[1117]","[TITLES].[PARENTH1].[1292]")

Arguments:

1. List of ID's - comma separated

2. Report ID

3. First member - full ID

4. Second member - full ID

5. ...

Vadim

[Former Member]

Hi

I can't find in my EPM

=EPMOlapMultiMemberO(

I only can see:

= EPMOlapMemberO

= EPMOlapMemberC

Thanks

[former_member186338]

For the page axis dimension open member selector and enable multi member. Select 2 members and look on the resulting formula.

Vadim

[Former Member]

Hello

Maybe I did not explained well my objective.

Each column have own objective.

please find what I want to achieve

Thanks.

Regards,

[former_member186338]

Sorry, but your explanation is still not clear. Multi member is only applicable to PAGE axis dimension. Please spend some time to explain what you want to achieve.

Vadim

[Former Member]

Hi,

Sorry for providing too much resumed information.

I want to create something like a report

for example

This MODEL received data from another two models: HR and OPEX and already have the data. Just need to read correctly to PNL

got it?

[former_member186338]

Sorry, looks like you are unable to explanation what you want. You show some screen shots without explanation where do you have axes etc... And I have to repeat again - it's not possible to use multi member in column or row axis - only in page axis.

[Former Member]

I want to develop a report where I can compare values from Actual (Historical) values and Budget values.

The Final_Model have two sources_models: HR_MODEL and OPEX_MODEL. Both are sending the AUDITTRAIL, InputHR and InputMKT where I can differentiate.

If you say that it is not possible to have multiple members, what would be the solution? I was thinking:

1. Create another report and share the same axis?

or,

2. Change the Target Audittrail to same like InputBudget

or

3. Create another column and create a localmember where sum InputMKT and inputSP?

any another solutions?

Thanks.

Regards,

[former_member186338]

"1. Create another report and share the same axis?" - how it will help?

"2. Change the Target Audittrail to same like InputBudget" - depends on you requirements for audittrail - "where I can differentiate."???

"3. Create another column and create a localmember where sum InputMKT and inputSP?" - possible!

4. Create parent audittrail for both InputHR and InputMKT and use it in the report!

Vadim