Hi I have a planning model with two identical dimensions in it , Account (Account Type) and GL Account (Generic). Initially we used GL account dimension to mitigate the single hierarchy issue that we could create on top of Account Type dimension,...

Hi From strange reason Custom Sort functionality is not working with restricted account (on Account Type dimension) from the last few months - I have created many similar custom sorts in other stories and they are still working fine. This dimensio...

Hi Every one I'm trying to drill down to transaction details using linked analysis functionality but it seems Account dimension values are not passing to Data point selection to get the correct the transaction details. In my first table I have Co...

Hi I'm building a P&L report in SAC Canvas/Table object. I have Sales, Cost of Sales ,Gross Margin, Labour Costs, and MCP as rows and Act, Bud, and Variance as columns. When calculating variance, for Sales row it should be (Act - Bud) but for Cost...