Hello,
What is the best way to copy paste the locks, protects and holds within a cube to the various versions in a cube or to the elements of another dimension. Currently, I am doing it manually for all the elements of the dimension.For eg:
In a cube there is Sales, Products, Time and Version. Sales has many calculations, products has 5 products, Time has months and years and Current Forecast and Previous Forecast for versions.
I have added 2 new products, so I open the cube and keep the Sales, Time and Version as is and change the Products to apply my locks, protects and Holds. Because we have 4 entities in teh cube when the data is viewed in a slcie and dice way, the lcoks and prtoects don't get applied in all slice and dice.
My question is, is there any better way to do this in all the slice and dice situation within the cube?
Thanks for your time.
Best!
Hi Cognos_World,
To make sure I understand your question -- you're looking for a more automated way to impose the required locks and protects in Analyst on new Products that are added rather than manually going through each slice and putting the locks in place?
You might be able to accomplish this with a Macro, specifically the @DCubeCommand macro step.
The macro would look something like this:
@DCubeCommand("Lock";"DETAIL";{Selection from D-Cube go_capex_contributor.Asset purchases})
@DCubeCommand("Protect";"DETAIL";{Selection from D-Cube go_capex_contributor.Asset purchases})
*Note: the selection is not visible, you have to click on the Edit DCubeSelection button to reveal what is being targeted with these macros.
Maybe this will help.
Cheers,
E
Hello
If you only want to apply the lock, protection to some of the detail items in the D-List you can try using a variable in the analyst macro with @DCubeCommand. This means that you will be prompted to select the items you want when the macro runs.
However, I suspect that Eric has your requirement covered.
Regards
Stuart
Excellent idea, Stuart -- that's even easier and a little more dynamic than the method I described.. I like it! ;)
Great... That was helpful. Thanks Eric & Stuart.
Had another question regarding the same.
Is there any precedence for Lock, protect & Hold? I tried on one of the cube cells and it did all the 3. I was trying to find a way to minimize the selection process. Two of my D-List is huge...the Sales and the Time.. and I have bunch of cubes on which I need to do the locks, protects and holds.
Thanks again!
From memory, you can set a variable for use in a macro command on a D-List. So should be able to reuse on several steps in the macro. Not tried it recently though.
Stuart
Hi Stuart,
Sorry if I was not clear in my question. I wanted to know if there is any precedence for Lock, Protect, Hold?
Thanks.
Hey 'World..
There really isn't a precedence, each setting is used to modify the way the cells interact with data input and the method by which the data was inputted. Take a look at the below link, specifically page 180 which goes into detail of each type and the way it affects the cells.
http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/planning/8.3/cp_a.pdf
Cheers.
Thanks Eric..