How to take level zero export of dense dimension
SummaryHow to take level zero export of dense dimension
I would like to take the level zero export of my account dimension. If we use DataExportLevel LEVEL0 in options, it takes export for all the level zero sparse blocks combination which contains all cells in that block. So, my query here is how to limit the cells in the block?
I tried it using fix statement as FIX( Relative("Accounts",0), Year, Period) and ran the script. But still, it exports the higher level members in the account. Even my period is dense. But as I have fixed my month, it works only for my month. And not working with my account and simply ignore the fix on the script.