I received an error msg regarding the workspace exceeding the size limit when I wanted to add more lists into “Applies to” as I added an additional context/page selector and needed to add up the figures with an additional criteria in the formula bar using the sum function
Is there a way to resolve this issue?
Kindly refer to the attached pic for more details.
Aw, bummer. You've exceeded your workspace limit. But there's good news. Best way is to get some space back is to archive some models that aren't being used. If your a workspace admin you can do this yourself, or work with your tenant administrator. In the past, I've cleaned up many workspaces and typically I'll give everyone a heads up that I'm archiving their models if they haven't been used in the last 30 days or so. Some are more obvious like app hub downloads that take up a lot of memory. Hope that helps!
@JaredDolich I don't think that a 236 GB model will fit into a 130 GB workspace. Current size i 52 GB. 😉
@DarrenS Can you explain what you mean with "my intended page selectors"? Is it just for filtering or also calculations on all dimensions? The second would require the use of combined hierarchies if you want to have all these dimensions in the same module with calculations on all dimensions.
I'm actually adding these page selectors as filters but i guess it would involve calculation so that the data is linked up properly with the various selectors. How do i do this in a more efficient way that doesn't take up too much space
- If dimensions are NOT required in SUM, but only for sync / filtering only.
Include all the dimensions only in the top-applies to and utilise additional line items with checks on specific list properties. Not sure what the relation is between your lists, but it could be a line item that has Industry and Segment included and a check like Industry.Segment = Segment, given that Segment would be a property of the Industry list. This can help then to show only the Industry list items with the selected segment. Just be careful to remove always all dimensions from the applies to before adding new line items.