Retrieval of list of members from a report

[Former Member]

Hi Everyone,

We have a scenario in our project. We need to get the list of members that are overridden for the specific dimensions from the report.

How can we achieve this functionality?

Thanks,

Thanuja

[former_member186338]

Sorry, but not clear!

"We need to get the list of members that are overridden for the specific dimensions from the report."

You have EPMDimensionOverride formula...

What do you want to achieve?

And how - using VBA or some formula?

Please provide screenshot of the desired result.

Vadim

[Former Member]

Hi Vadim,

The Requirement is

1.  I have an Input form wherein I will enter some data at combination of dimensions. Based on the data entered, the data will get saved for that combination.

Fund, Fund center, Commitment item, Decision, Partner Fund, Partner Fund center, Partner Commitment item, Flow are dimensions.

2. I will take a report whose partner Fund is FG1, Partner Fctr is FC1, Partner Commitment item is CI1. I will get the following report.

From this report I need to get the dimension values that are available in the report for Fund, Fund center, Commitment item dimensions(FG2, FC2, CI2) & (FG1, FC2, CI1) and override on another input form for partner fund, partner fund center, Partner commitment item dimensions and save the negation of these values(-5000, -5000) to (5000, 5000) and save it in Debit flow.

Output sheet which is to be generated is as follows:

Please help on this.

Thanks,

Thanuja Sekar

[former_member186338]

Sorry, but I am unable to understand the logic you want to achieve...

[Former Member]

Hi Vadim,

I don't have any idea why you are not clear even though the screenshots are provided.

The thing is simple. From one report, I should find out the members that are coming in the report for the specific dimensions and override the same in another input form which I want to create.

The case is that the report from which I am going to use will be displayed based on the data available. I am giving override for all the members in the report and checked Remove empty option,. So it will display only the members that are having the values.

From this I need to find the members which atre having the values for each dimension and override the same in another input form.

Hope it is clear now.

Thanks,

Thanuja Sekar

.

[former_member186338]

"find out the members that are coming in the report" - what do you mean by "coming"?

How member selection is done?

Absolutely not clear!

[Former Member]

Ya Vadim. I will have a selection of fund and fund center. Based on that partner Fund and Fund center which are in the column axis will be overridden.

And in the Fund and Fund center dimensions which are in the row axis, I will give the override for all members. But the option for removing empty is et. So only the fund and fund centers which are having values will come in the report.

That list of members which are displayed in the report I need to find out and overrides another report with these members.

Thanks,

Thanuja

[former_member186338]

Looks like you don't understand my questions...

"I will have a selection of fund and fund center. Based on that partner Fund and Fund center which are in the column axis will be overridden."  - absolutely not clear!

Sorry!

[Former Member]

Vadim,

The issue which we were trying to find the solution got resolved.

Just a gist of the issue and the solution.

I have a selection of Fund, Fund center.

Report structure is as follows:

Row axis : Fund, Fund center, Commitment item, Partner Fctr, Partner Fund, Partner Commitment item, Flow.

Column axis : Time

Based on my selection of Fund and Fund center, Partner Fund, Partner Fund center dimension will get overridden.

Note : Fund and Partner Fund have the same set of values. Its the same for others also.

For Fund and Fund center dimension I will override all the members in this report and kept the option for removing empty set.

So I will get a report which displays the Fund, Fund centers which have values.

From this report, I need to post a value by reversing the Fund and Partner Fund, Fund center and Partner Fund center, Commitment item and Partner Commitment item.

This is achieved with the help of EPMSaveData Function in Excel.

Please see below the combinations used :

First Combination :

Second Combination :

In this, I am saving the negation of data that is saved against the first combination and post in a second combination.

Hope it is clear now.

Thanks,

Thanuja

[former_member186338]

I still do not understand what do you mean by "Based on my selection of Fund and Fund center, Partner Fund, Partner Fund center dimension will get overridden." - overridden - how? With EPMDimensionOverride or?

EPMSaveData is very slow on huge input forms and can have some strange results... But in some cases can be an option.