Hello,
I found that the Chart of Account dimensions(created using ODBC TI process, "GL_Account" dimension) has got a wrong hierarchy. I created a new one using XDI and called it "R_Accounts" dimension. Can I substitute the "GL_Account" dimension with the
"R_Accounts" dimension without recreating the cube? I tried to delete the "GL_Account" dimension but the dimension is greyed out. Any ideas?
Can I replace a dimension after a cube is created
- Steve Vincent
- Site Admin
- Posts: 1054
- Joined: Mon May 12, 2008 8:33 am
- OLAP Product: TM1
- Version: 10.2.2 FP1
- Excel Version: 2010
- Location: UK
Re: Can I replace a dimension after a cube is created
Telula,
Please don't take this the wrong way but it sounds like you'd really benefit from a TM1 developer training course from Cognos (assuming they do them in your area). It should give you a good basis to start your TM1 career, unless you have people in your organisation that can train you themselves?
Once a cube is created, that's it. You can not substitute one dim for another or add / remove dims from it. The only option in these cases is to delete the cube and start again. In your case it just sounds like the elements are not right in the original dim, so all you need to do is delete those elements then re-insert them in the same way you've built the other dim. As long as you have the same level 0 (nodal) elements in both the old and new versions, and you delete and insert them in the same TI / or rebuild via XDI, you shouldn't loose any data either.
Please don't take this the wrong way but it sounds like you'd really benefit from a TM1 developer training course from Cognos (assuming they do them in your area). It should give you a good basis to start your TM1 career, unless you have people in your organisation that can train you themselves?
Once a cube is created, that's it. You can not substitute one dim for another or add / remove dims from it. The only option in these cases is to delete the cube and start again. In your case it just sounds like the elements are not right in the original dim, so all you need to do is delete those elements then re-insert them in the same way you've built the other dim. As long as you have the same level 0 (nodal) elements in both the old and new versions, and you delete and insert them in the same TI / or rebuild via XDI, you shouldn't loose any data either.
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Re: Can I replace a dimension after a cube is created
Steve,
Thanks for the suggestion but I have already been to a developer course but as in all courses, they dont cover much.
And you only discover these other things when you start doing these yourself. If you find my questions tiresome, then please dont bother replying.
Thanks for the suggestion but I have already been to a developer course but as in all courses, they dont cover much.
And you only discover these other things when you start doing these yourself. If you find my questions tiresome, then please dont bother replying.
- John Hobson
- Site Admin
- Posts: 330
- Joined: Sun May 11, 2008 4:58 pm
- OLAP Product: Any
- Version: 1.0
- Excel Version: 2020
- Location: Lytham UK
- Contact:
Re: Can I replace a dimension after a cube is created
Steve - I don't think she liked your suggestionIf you find my questions tiresome, then please dont bother replying
Telula - maybe you ought to adopt a slightly less prickly attitude if you really want help form experts like Steve - It helps to stick around and read a bit to gauge the tone of the place before posting - this is one of the most laid back and helpful forums you will ever find - no need to get defensive here.
Please do keep posting, but do take the advice in the spirit in which it is given
John Hobson
The Planning Factory
The Planning Factory
-
- Site Admin
- Posts: 1453
- Joined: Wed May 28, 2008 9:09 am
Re: Can I replace a dimension after a cube is created
Interesting question. I am working with a client at the moment where we built some cubes with dimension names which on reflection the client team weren't happy with. I asked for a document setting out the changes, and then did the following:
a In the file system, copied the xx cub file to xx_old.cub;
b In Perspectives, opened the dimension and saved as new name;
c Also in Perspectives, opened the rules file and copied it into Wordpad (to preserve the formatting);
d Recreated the cube using the new dimension (in the same position). This replaces the cube;
e Pasted back the rule and changed the references, using search and replace;
f Restarted the server;
g Copied the data from the xx_old cube (which appears on restart) to the new cube, using my favourite quick fix, relative percentage spread.
Fiddly? Yes. Worked though.
HTH
a In the file system, copied the xx cub file to xx_old.cub;
b In Perspectives, opened the dimension and saved as new name;
c Also in Perspectives, opened the rules file and copied it into Wordpad (to preserve the formatting);
d Recreated the cube using the new dimension (in the same position). This replaces the cube;
e Pasted back the rule and changed the references, using search and replace;
f Restarted the server;
g Copied the data from the xx_old cube (which appears on restart) to the new cube, using my favourite quick fix, relative percentage spread.
Fiddly? Yes. Worked though.
HTH
- Roger_Lewin
- Posts: 17
- Joined: Mon Nov 03, 2008 8:25 am
- Version: 9.4 MR1 FP1
- Excel Version: 2003
- Location: Ratingen, Germany
- Contact:
Re: Can I replace a dimension after a cube is created
Why dont you simply delete all elements from the dimension via TI and replace them with the correct hierarchy? if the measures are saved to the same elements, no values are lost.
Take a look at DimensionDeleteAllElements in the Help Files
Take a look at DimensionDeleteAllElements in the Help Files