Skip to Content
Former Member
Mar 04, 2008 at 06:43 AM

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


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’.


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.