BI Hierarchy Refresh

Post Reply
User avatar
jim wood
Site Admin
Posts: 3494
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

BI Hierarchy Refresh

Post by jim wood » Thu Sep 07, 2017 3:42 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

declanr
MVP
Posts: 1541
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 » 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?

User avatar
jim wood
Site Admin
Posts: 3494
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: BI Hierarchy Refresh

Post by jim wood » Fri Sep 08, 2017 12:22 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

User avatar
jim wood
Site Admin
Posts: 3494
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: BI Hierarchy Refresh

Post by jim wood » Fri Sep 08, 2017 12:52 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

declanr
MVP
Posts: 1541
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 » Sat Sep 09, 2017 5:33 pm

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.

User avatar
jim wood
Site Admin
Posts: 3494
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: BI Hierarchy Refresh

Post by jim wood » Tue Sep 12, 2017 12:52 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

Post Reply