Problem in displaying Master Data in the layout with no transaction data

[Former Member]

Hi All,

We have multiple WBS elements(0WBS_ELEMT) for a Project(0PROJECT). Project is an attribute of WBS. Initially when there is no data in the cube, if the user selects the Project in the selection screen, I want the list of all WBS elements for that Project, so that he can plan for those WBS elements in the layout by entering some values in the keyfigures.

In the Query Designer in the Advanced tab – ‘Access Type for result Values’ is set to “Master Data’ and also ‘Filter Value Selection During Query Execution’ is set to ‘Master Data’.

Obervations:

When no project is selected in the filter variable, it displays all the WBS Elements for all the Projects though there is no transaction data (with all the keyfigure values as 0).

If we select a Project in the filter variable, then it gives as ‘No Data Available’

Please suggest how to get the list of all WBS Elements (with 0 KF values) for a selected Project though there is no data.

Regards,

Saritha

[former_member317284]

Hi Saritha,

please try the following:

1. Create a new variable of type exit or replacement path for WBS-element. This variable should deliver all WBS-Elements of the selected project (your other variable).

2. Add the new variable to the filter of the query.

When you execute your query and select a project, all WBS-elements should be in the filter and you can show the data with the "master-data-option"

Hope it works

Thomas

[Former Member]

Hi Thomas,

Tried with Customer Exit option. Created the Customer Exit variable wherein it was populated with WBS master data and also set the option as 'Master Data'. Then we are getting all the WBS Elements for that project though there is no transaction data.

But in the report we are not getting input enabled empty row for each WBS element. Rather we are getting new row at the end.

The output is someting like this.

WBS Element Project Definition Trans Curr Amt

CT.0012.AE10.10.01.001 Result

CT.0012.AE10.10.02.001 Result

CT.0012.AE10.10.02.002 Result

CT.0012.BE10.10.01.001 Result

CT.0012.BE10.10.02.001 Result

New row at the end.

Pls suggest how can I get input enabled empty row for each WBS even when no transaction data exists.

Thanks and Regards,

Saritha

[Former Member]

Hi,

Have you set this property (in advanced tab) for both WBS element and Project?

[Former Member]

Hi Mayank,

I have set this property for both WBS Element and Project as well.

Regards,

Saritha