Skip to Content
0
Former Member
Jul 18, 2016 at 09:33 PM

No data in initial View of Data source

270 Views

SAP BusinessObjects Design Studio

Release 1.6 SP1 Patch 2 (Version: 16.1.2)

Source: Relational database, thru UNX

my Initial Application settings:

All my Datasources have "load in script" set to True. Merge Prompts is set to False. Force Prompts on startup is also set to false.

I created a datasource (Region, Sales as column and Region prompt from universe) and was able to set the initial view of the data source. Now when I add more columns like Year, Month and Area and preview the data, i see the results. The initial view of the datasource gets reset and when I try to set it again, get the error:

"problem while accessing data. this might be due to the current selection of variables or filter values."

While previewing the data, it prompts for Region prompt and I enter the value and get the results. But when I try to set the initial view, is it taking that saved test value of the prompt? It does not prompt for a value and thus I'm not sure if it is trying to run the query for all regions and as the data is huge, it doesn't return any data ?


I tried searching for more details on this error message but couldn't find much information:

https://scn.sap.com/thread/3366235

http://scn.sap.com/thread/3506090

Can anyone help me with reducing the data in the initial view so that I can view and set it? Also I cannot put any hard-coded filter on region (which is the mandatory prompt, each user logging in will see his region only), it has to be dynamic [ when the application is run for the first time by the user, the whole application runs for the first value in the region prompt drop-down (which will be different for each user) and latter for subsequent runs, he can change the region].

Thanks,

Srikanth

Attachments