Dynamic POV in epm excel reporting based on transaction data uploaded

[former_member339201]

Hi all,

We are trying to have dynamic POV selection for user in excel epm reports based on transaction data data uploaded by the user via the flat file.

The scenario is like below :

The user uploads the flat file like below :

A     B     C     D     E     SIGNEDDATA

q     w     e       r      t           10

z     x      c       v     b          20

g     h      j        k     l           30

Here A,B,C,D,E are dimensions. Rest are dimension members.

Now in some of the reports user wants the POV selection like this :

A     (Selection of Dimension A, where he sees only members q,z,g)

B     (Selection of Dimension B, where he sees only members w,x,h)

C     (Selection of Dimension C, where he sees only members e,c,j)

*******************************************************************************************************

The user does not want to see the entire dimension members for the given selection of dimension.

We are looking for efficient ways in which it can be done considering long term performance issues also.

Please suggest.

Regards,
SHUBHAM

[Former Member]

Hi Shubham,

One solution is you create properties for those dimensions, then in your report you filter on those properties, so only those with the matching property will list.

you need to use epmcontext formula in your report with filters.

Depends on how many users, you can come up with special groups if there are more than one user.

Andy

[former_member339201]

Hi Andy,

Thanks for the reply.

The flat file upload may vary by records and so will the dimension members.

So maintenance of property will be tricky as the combination is variable.

Regards,
SHUBHAM

[Former Member]

Hi Shubham,

Ok, then alternative would be using routine, create a new dimension and in the routine you populate a member for the new dimension, it can be time stamp or any marker that suits you, then in the report you just show members in that new dimension.

Andy

[former_member186338]

The only thing that can be implemented is "No Data and Zero Values" report option. Only members with data will be shown on the report..

[former_member339201]

Hi Vadim,

Thanks for the reply.

This is not a  report which user sees just after data upload, In that case we would definitely give them No Data and Zero Values option in the report.

But after upload user does a series of other calculation steps and inputs, and then after that in one of the reports he wants to have the POV selection as mentioned above.

Regards,
SHUBHAM

[former_member186338]

Use AUDITTRAIL to differentiate uploaded data and data inputted or calculated. Then you can use no data suppression...

[former_member339201]

Hi Vadim,

The uploaded data and calculated one is at different AUDITTRAIL.

In the report we are showing the calculated data, and the basis of calculation is the uploaded combination of data which user wants to see in POV selection.

[former_member186338]

You can use 2 reports with shared row axis:

First will be for AUDITRAIL UPLOAD with zero empty supression for rows!

Second - the required report!

[former_member339201]

Vadim,

The rows to be shown in both reports are different

[former_member186338]

Sorry, please specify you requirements with full details and with report screenshots... Unable to help without full info.