We are following the article (http://www.keyperformanceideas.com/outline-tuning-modified-hourglass) on outline tuning.
We use Sample outline as shown below.
The author says - Set one dimension at a time to Dense and all other as Sparse. Run the load and then check the block density.
For example - we start with setting Year as Dense and all other dimensions as Sparse. Run the data load using rules file.
Then in the application- Edit- Properties - Statistics, check the Block Density. Make a note of it. Run Calc script. Check again the Block Density.
In this manner we have to proceed with rest of the dimensions.
The issue is when I try to set Product as Dense, I get an error message that says other attribute dimensions are associated with Product.
In the following snapshot I have shown the warnings/errors. See here.
There are two questions.
I tried checking the four attribute dimensions ( as shown above) to see how they are attached to Product. But I was not able to find. May be I am not seeing the correct options.
Secondly, how do I resolve this error ? HOw do I make Products as Dense and all others as Sparse, save the outline, and then run the load ?
For the time being just for testing purpose, I removed the attribute dimensions (see below), with that I was able to save the changes and do the changes as mentioned in the article
However the issue is I have to keep the same original outline ( see the topmost image) and do the changes as mentioned in the mentioned article. Could you please help ?