Display Absent Dimension properties

[former_member693894]

Hello Experts

There is a team of users who update the dimension members (Masterdata) in BPC admin consol and they need a report, and this report should display the missing dimension properties of the Product dimension. The product dimension is having more than 75000 rows and 28 columns (Dimension properties) so we dont need all the rows in the report but only the missing values of the dimension properties.Can someone help me ?

Thanks

Sncy

[William_Yu1]

Hi sumeth.radhakrishnan,

Not sure if you really need a sperate report for that. I guess your users just need to find out empty properties and make sure that they are correctly maintained. In the master data maintenance screen in web admin, user can different use filter or sorting capability on column header of each property to find out emtpy property rows.

Best regards, William

[former_member186338]

"Is there a way we can create a report itself so it be of help to them."

For sure, it's possible to create a report with 28 local members (for each property) but for 75000 lines it will be extremely slow!

[former_member693894]

I was thinking of using EPMdimensionpropertyvalues , as it displays the member list and also the empty ones, but my problem is how to retrieve the member id. Is there any way I can get the id

[former_member186338]

sumeth.radhakrishnan

Sorry, but EPMdimensionpropertyvalues is completely useless for your requirements! It will simply provide the list of values possible for some property - not related to ID.

You have to create local members like:

=EPMMemberProperty("CONNECTION_NAME", EPMDIM_CURRENT_MEMBER(DIM_NAME), "PROPERTY_NAME1")

and use it in report showing all members.

[former_member693894]

Thanks a lot Vadim for the reply ! , but unfortunately the users have a very restricted profile and does not have the export privilege. Is there a way we can create a report itself so it be of help to them.

[former_member186338]

Sorry, but please, don't use "answer" when you are not answering to your own question! Use comment!

[former_member186338]

Using DM package (MD Export to file) export all members into tab separated text file.

Open this file in Excel (75000 rows is ok) and apply Excel autofilter.