Option of Selecting Entity when NO WBS is selected?

[pankajkumar_gilda79]

Hi All,

    I am looking for a solution where in there is a selection process by which the template gets its parameters:

In the same template can I have the option of :

1. If I have WBS then the Entity is automatically populated. I Have maintained property ZENTITY in WBS Dimension.

2. If I have NO_WBS then the user needs to select the Entity on his own.

NOTE: I have kept my ENTITY in PAGE AXIS.

I tried the same in the following manner but the problem is I am unable to Display the name of entity when NO_WBS is selected. Though I am able to send the data to the selected Entity properly.

PFA screen shots:

1. If I have WBS then the Entity is automatically populated. I Have maintained property ZENTITY in WBS Dimension.

2. If I have NO_WBS then the user needs to select the Entity on his own.

  As per the pic the selected entity is HOFLWBK. But it is not displayed in the Column.

   Any suggestions.

Regards

KMG

[former_member186338 · Accepted solution]

Please provide more details:

What do you have in page axis?

How user select WBS?

...

And it's not possible to have a single cell to achieve what you want!

Vadim

[pankajkumar_gilda79 · Accepted solution]

Hi Vadim,

   In Page Axis I have ENTITY Dimension.

WBS Dimension has ZENTITY property

ID                    DESC        ZENTITY

R_RIG101      WBS1          RIG101

NO_WBS        NO_WBS      

ENTITY Dimension

ID                    DESC         

RIG101          Entity1

So when the User Selects the WBS the Entity is fetched automatically. Now when the user wants to enter the plan for Head Office Cost Center there will be NO_WBS. In this case the user has to select the Entity from the Context.

But if you see I have been able to get it done except the thing is Entity name is not displayed:

the formula in the Page Axis which I have maintained in next cell of the Selected Entity: i.e Cell I17

In cell C4

If it cannot be achieved in one cell then I need to create to two Input Schedules.

Regards

KMG

[former_member186338 · Accepted solution]

Something like:

1ELIM is like NO_WBS

Then cells B2 and B3 has to be referenced in the EPMOlapMemberO formulas of page axis...

Vadim

P.S.

TITLE - WBS

BE - Entity

[former_member186338 · Accepted solution]

Logic:

User double click B2 to select TITLES

If TITLES is not 1ELIM then B3 will be the PLANBE property of TITLES.

If TITLES is 1ELIM then B3 will be equal to B4. And in B4 user is able to directly select BE.

Hope it's clear...

Vadim

[former_member186338 · Accepted solution]

Small mistake in the formulas, full picture:

Vadim

[pankajkumar_gilda79 · Accepted solution]

Thanks Vadim. It worked.

Can this be used whenthe WBS is in ROW Axis instead of PAGE AXIS.

[former_member186338 · Accepted solution]

What do you mean by "this"?

In a row axis you can only permanently link one dimension to the property of another dimension!

Vadim