Unable to modify dimension

Post Reply
mukeshrajdass
Posts: 36
Joined: Tue Sep 07, 2010 11:34 am
OLAP Product: Cognos TM1
Version: 10-2-2
Excel Version: 2014

Unable to modify dimension

Post by mukeshrajdass »

Hi

Seems a bit strange..working on a customer site..tried to EDIT a dimension under Architect/Perspective and move a child element from one to the other...After saving and exiting...It reverts back to the original ????

Why is that ? Is it because it was edit via XDI and refuses to accept any direct editing ? No Security access issues...

Am i missing the obvious AGAIN !! ??

Is this another DUH situation ?
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Unable to modify dimension

Post by tomok »

Please tell me you didn't double-click on the dimension in Server Explorer in order the "edit" it.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Unable to modify dimension

Post by macsir »

Have you done a dimension save in the sheet?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
mukeshrajdass
Posts: 36
Joined: Tue Sep 07, 2010 11:34 am
OLAP Product: Cognos TM1
Version: 10-2-2
Excel Version: 2014

Re: Unable to modify dimension

Post by mukeshrajdass »

I did edit in the Server Explore - Edit Dimension..Why ?
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: Unable to modify dimension

Post by Martin Ryan »

Hi Mukesh, hope Auckland's treating you well.

Can you please screenshot the before, during and after situation?
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
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Unable to modify dimension

Post by Alan Kirk »

mukeshrajdass wrote:I did edit in the Server Explore - Edit Dimension..Why ?
Because a lot of people (especially new users) do open up Subset Editor and think that they're editing the dimension.

I really don't like dimension editor, at all. I use it under duress from time to time but wherever possible I do low maintenance dims through an .xdi and high maintenance dims through TI.

That having been said, you should NEVER edit a dimension which uses an .xdi through any method other than its .xdi. If you add a new element through the Dimension Editor (say) and add an element, then someone comes along and thinks "Oh look, an .xdi" and goes ahead and recompiles it, then bang, you've lost your element and you've lost your data. In theory the Dimension Editor should ask you if you want to update the .xdi sheet, in practice that may not always happen, depending on where the sheets are stored.

I believe that the core problem is that the Dimension Editor is just "finnicky", which is why I really don't like it. I've found that when it ignores my structural changes I can sometimes force the issue by adding a dummy element after I've done my changes, saving the dimension, going back into the editor and deleting the dummy element. You can try that and see whether it makes a difference.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Unable to modify dimension

Post by tomok »

mukeshrajdass wrote:I did edit in the Server Explore - Edit Dimension..Why ?
Because if you double-click to edit a dimension you aren't. You are in subset editor, which for some very stupid reason, looks almost exactly like the dimension editor. If I had a nickel for every person that has posted in here thinking they were trying to edit a dimension and couldn't understand why it didn't work, and they were actually working with a subset, I could quit my day job and just harass people here full time.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Unable to modify dimension

Post by jim wood »

Also telling us what version you're working on will help. I've noticed some strange behaviour with the dimension editor in version 10.1,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
mukeshrajdass
Posts: 36
Joined: Tue Sep 07, 2010 11:34 am
OLAP Product: Cognos TM1
Version: 10-2-2
Excel Version: 2014

Re: Unable to modify dimension

Post by mukeshrajdass »

Yep 10.1
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Unable to modify dimension

Post by jim wood »

The funny stuff I saw started with copy and paste not working, also it wouldn't save dimension changes. Stopping and starting the service seemed to sort it out,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply