Line chart without data

[deepak2k2]

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.

[Arpitagrawal9]

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.