Forum Discussion

Rithik_Prem's avatar
Rithik_Prem
New Contributor III
2 years ago

How to Achieve dynamic data retrieval: Current month + 12 months prior using SQL in Dashboards

Hi All, I am currently facing a challenge with my SQL code in dashboards and would greatly appreciate your help in finding a solution. The issue at hand is that I have hardcoded the code to pull dat...
Dashboards
Parameters
Reports
JackLacava's avatar
JackLacava
Honored Contributor
2 years ago

I'll be that guy: this might be done in an easier manner with a Cube View (where expanding Time with functions is trivial), either coupled with a Data adapter of type Cube View MD (which allows you to loop over 2 dimensions, for an effective total of 4+2+2 expandable dimensions) or with a Dashboard Dataset using an FDX call (which you can execute over and over to keep looping on the CV, or even just simply point at the DataUnit, hence without limits on the number of expandable dimensions).