Anchor POV dimension placement
SummaryAnchor POV dimension placement
we are using smart view 710, essbase verison 18.104.22.168.508, Microsoft Excel 2016.
Our file consists of several worksheets of smart view report. In order to update the dimensions for all worksheets in the quick and efficient manner, we choose to have the first worksheet that will have trigger change in dimensions in the rest of the worksheets.
Example, if I choose Jan as the month in the first SV report, all the month dimensions of subsequent SV repots will be updated because I put in an excel link in them under the month dimension to the first SV report.