Element change in Dimension

Post Reply
Rayan12
Posts: 18
Joined: Sat Mar 16, 2013 12:07 am
OLAP Product: Cognos EX
Version: 9.1.1
Excel Version: 2010

Element change in Dimension

Post by Rayan12 »

We are using Cognos Express Planning Ver10. In Architect module we have one cube which in production. Now I am planning remove all element from one Dimension and upload new element in same dimension and adding one more level in dimension . We are using Forecast in Planning modules.
My Question is 1) after this changes what will happen with our current views which already published in Planner Application? what I have to do?

2) What are the risk factors after change the element in dimension ?

## 3) Basic Question : What are the steps from 'Cube build in Architect' to Published the cube in application for data entery in forecast module?

Please help me.
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Element change in Dimension

Post by Martin Ryan »

1) Your views will probably have to be rebuilt and republished if you're removing all elements from the dimension and replacing them with completely new ones.
2) All your data will be deleted. All your views will have to be rebuilt.
3) Documentation is the best place to resolve this one as it will cover off all the steps in more detail that you'd get from a quick forum reply.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Element change in Dimension

Post by lotsaram »

You should investigate swapping alias and principal name with TI. This could avoid having to reload any data. First change the element name then just add the new parent (which I assume will have the same name as the current N element).
Rayan12
Posts: 18
Joined: Sat Mar 16, 2013 12:07 am
OLAP Product: Cognos EX
Version: 9.1.1
Excel Version: 2010

Re: Element change in Dimension

Post by Rayan12 »

Thanks. Can I copy and Paste all views in Cube ? My DRP Plan is Copy CXMD folder and Take Application Backup , if some thing goes wrong then
i will restore CXMD and Application Backup. In that case will i get back all Data and Application( Views,Security )?

Thanks Again.
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Element change in Dimension

Post by lotsaram »

Did you look up SwapAliasWithPrincipalName like I recommended? This would avoid you deleting any elements and would be much simpler if you do it correctly! (I would always still do a data directory backup first.)
Post Reply