HI Gurus,
In the advanced tab of the analysis I have enetred columns and the group by and clicked on Apply SQL. Later I realised that it has disabled the hierarchy and members selection and other thing sin my report and in dashboard.
Though I have selected 3 columns to calculate this was impacted by all the hierarchial and memebers selection columns. Could some one please help me in getting back the those features into Dashboard and in Catalogue.
Or Could someone please suggest me the turnaround to get that back as it was impacted other reports pointing to those columns.
If I logout and Login then the Dashboards pointing to that columns are working fine, but when I run the analysis on those columns for aggregation or group by then that will be showing the error
VIEW DISPLAY ERROR:
ERROR GETTING DRILL INFORMATION select ....
please find the error attached
error.PNG (29.16 KB)Thanks,
Vicks