Property based reporting

[Former Member]

Hi,

We are trying to design a template to bring in the customerwise Rev and Costs based on the entity  (Dimension is maintained) and customer type property maintained in the Customer dimension.

In the Customer dimension, we have maintained a property to  as”Customer type” to identify the customer as “New” or “Existing”.

The user is willing to select the new or existing customer type in the template from a drop.

I knew there is a filter function in the customer master (in edit report) to filter based on property, but the users requirement is to select the property in a drop down in the template instead of going to edit report.

Please let me know if we can use Dimension override function and let me know how to use it if applicable. Also let me know if there is any other alternative to use the same.

Kindly help me with the same.

Regards,

Shilpa

[Former Member]

Hi Shilpa....

So many threads on scn regarding EPMDIMENSIONOVERRIDE are available......use search and help!

some listed below:

Dynamic member selection with properties in ver... | SCN

Else if possible...you can also create a hierarchy in customer dimension instead of property. Then you can give EPMcontext member in selection to user by restricting it to only parent nodes! In Edit report select the base of Context selection! The user will select a parent and accordingly all the customers will be populated in report!

Hope this helps...

Regards,

JP

[Former Member]

Hi,

May be this Link might help u.

https://wiki.scn.sap.com/wiki/display/CPM/EPM+Add-in+Academy?original_fqdn=wiki.sdn.sap.com&preview=...

[former_member186338]

Yes, epmdimensionoverride will do the job. Simply read help on this function.