Skip to Content
0

Design Studio - Termination Message sent ERROR RSQBW (000): ORA-00904: "T1"."DATE0"

Sep 22, 2017 at 01:17 PM

42

avatar image
Former Member

Hello.

I have an Analysis Application designed in SAP Business Objects Design Studio 1.6.
It uses 6x BEX Queries as Data Sources.
When I run this dashboard for Calendar Year / Week: 2016/26 then it works without problems. The dashboard has graphs, dials and crosstabs.

However if I run it for any other week then the dashboard opens up, showing the graphs without issue but if you click the button which should trigger the crosstab for display (PaneL) then it gives the error and bombs out.

We are currently in Calendar Year / Week: 2017/37.
I have checked as far as I could in terms of ensuring that everything is scripted correctly and that all the Data Sources are correctly configured in Design Studio. I cannot understand why it would work for one week, but for no other week.

A view of the working dashboard, the button to trigger the crosstabs are marked in red circles.


The message we get when working on any week other than 2016/26, and clicking the crosstab trigger.


What would be the cause of this and how can I fix it please?

dashboard.jpg (185.5 kB)
error1.jpg (369.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers