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.