Hello,
Is it possible to create a line chart without having a data from the Cube?
Eg. I need to plot a forecast value for each month. (Jan = 1000, Feb = 1500, Mar = 1500 and so on.) In my cube, Month is available but forecast value is not availabe.
Can I pass the forecast value in "DataItem" using the case statement for each month?
Thanks in advance.
You can create a Data item in your report query for Forcast value
The statement should be something like this
Case Month
When 'Jan' Then (1500)
When 'Feb' Then (1000)
.
.
.
.
End
You can drag this data item in the series and plot your graph wrt Month.
Let me know in case you still face any issue with the same.