BI Hierarchy Refresh

Post Reply
User avatar
jim wood
Site Admin
Posts: 3937
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:

BI Hierarchy Refresh

Post by jim wood »

Guys,

I am no BI expert. In TM1 we have been asked to remove a level from the hierarchy as follows:

Old
  • Total
    Department
    Facility
    Program
    Project
New
  • Total
    Department
    Facility
    Project
I have update the hierarchy control cube to remove the Program level. In the current TM1 BI reports that we have the number of levels has updated but instead of dropping the program it has left program in place and dropped the Total. What is displayed however works as when you select Department you in fact get Total. Is there any way to stop this from happening?

In workspace advanced it is displaying incorrectly as well,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
declanr
MVP
Posts: 1796
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: BI Hierarchy Refresh

Post by declanr »

Haven't seen it happen specifically like this but just to check, have you performed the mdx hierarchy refresh function in TI?
Declan Rodger
User avatar
jim wood
Site Admin
Posts: 3937
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: BI Hierarchy Refresh

Post by jim wood »

declanr wrote: Thu Sep 07, 2017 6:43 pm Haven't seen it happen specifically like this but just to check, have you performed the mdx hierarchy refresh function in TI?
No I haven't. Well you learn something new every day. I'll run it and let you know if that fixes the problem,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
jim wood
Site Admin
Posts: 3937
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: BI Hierarchy Refresh

Post by jim wood »

Looks like that did the trick thank you Declan. It's always good to learn something new. The next challenge at my age is to remember it!! :D
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
declanr
MVP
Posts: 1796
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: BI Hierarchy Refresh

Post by declanr »

No worries, if you haven't done it before it can be hard to think of the correct terms to search for in the user guides. A server restart also does the same job and I did a project a little while ago at a company that has a scheduled restart every night just in case anything like that had changed.
Declan Rodger
User avatar
jim wood
Site Admin
Posts: 3937
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: BI Hierarchy Refresh

Post by jim wood »

declanr wrote: Sat Sep 09, 2017 5:33 pm A server restart also does the same job
Also good to know as well thanks.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply