How to process Forecast reports in tableau from Multidimensional Data Source(Oracle Essbase) ?
I have a Time dimension consisting of Year,Month,Quarter and date. I am trying to build a forecast report using year and Sales amount,but the forecast option is disabled in tableau.
On surfing a lot I found that, since the year is in dimension n not in valid date format, forecasting can not be done.
Is there any other option in tableau to achieve the forecast report using my time dimension ?
Or any calculated field option ?
looking for help or suggestions !!!
I could do the forecasting report using relational DB , excel ,text as source but couldnt do it using multidimensional data source. help pls ....!!!