Question
Time Members in CubeView Rows
I have a requirement to build a Cube view with 4 Years of Forecast Periods (48 Months) in rows comparing the Current Month Forecast and Previous Month Forecast (Scenarios in Columns). There is various UD Intersections exist for this comparison (Region-Cost Center-Customer-Product).
I am seeing significant Performance degrade when I have the Time members in Rows. Report takes very long to render. Are there any tips and techniques that anyone could suggest having time members in rows with improved render time? Or is this not a good practice and should be avoided?
