Maintaining complete table structure, including column headers when there is no master data

[Former Member]

Hi All,

I have generated an input-ready, forecasting application using BEx tools, retrieving data from multiple sources.

Currently once the application is executed through Web Application Designer, only the months labelled with column headers 00 2016, through to 05 2016 appear within the table through the web. For this time period shown above, there has been dummy master data inputted.

For the time period labelled 06 2016 to 09 2016 in our table, we have NOT manually entered any data and the columns disappear completely.

As this is a forecasting tool, some months will inevitably be vacant before planning has been completed.

QUESTION: How do you configure the query/properties within BEx to enable all time periods and therefore columns in the table, to show regardless of whether there is master data retrieved or not?

,

Many thanks in advance,

Billy Haworth

[FCI · Accepted solution]

In the "Extended" tab of your Period characteristic in the query designer, select the "Master Data" Access type:

That should display all the existing periods in the master data even if they are unposted.

Regards,

Frederic

[Former Member · Accepted solution]

Brilliant - that works fine, thank you for your help!