The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
How to call Data Adapter in a Business Rule?
I'm working with a BI Viewer and working out how to sort the dates within the Time data set. Is their an API that allows to call the data adapter used within a dashboard?
Currently the dates on the...
Hi MarkHoughton
Apologies that I wasn't able to update this post earlier. But I was able to find a fix to this date issue -
You would need to switch this to TRUE
Now go back to your BI-Viewer. This should add "Start" and "End" Date data-items. Drag it to your argument pane and that should fix the dates on the axis. Hope this helps you save development time.
Hi ChrisLoran
I am also interested in finding out how this is implemented within a data-adapter that is referencing a Cubeview to supply the data to the BIV-chart. My charts are either sorted on the x-axis as alphabetised Apr,Aug,Dec etc or in the M1,M10,M11 format as described by Mustafa_A . How do we call this code when data is in a CubeView ? In the CubeView the data is sorted as expected in the Jan,Feb,Mch or P01,P02,P03 sequence, so I cannot see how calling this from within the CubeView will alter the data. If it requires it to be a Method query, then what is that syntax structure for including this and embedding the CubeView or wil the data for the BIViewer component need to be configured some other way ? Or is the date field as a Hdr description in the BIViewer edited via a calculated field method ?
Regards
Mark
Hi MarkHoughton
Apologies that I wasn't able to update this post earlier. But I was able to find a fix to this date issue -
You would need to switch this to TRUE
Now go back to your BI-Viewer. This should add "Start" and "End" Date data-items. Drag it to your argument pane and that should fix the dates on the axis. Hope this helps you save development time.
Hi Mustafa,
I appreciate the extra information in your solution. Thank you
Mark