Page 1 of 1

Hierarchy Changes affecting BI reports

Posted: Thu Mar 22, 2018 1:27 pm
by Reuben
Hello Gurus,
Sorry if question this has been asked earlier.
I have created several reports using Report Studio which works fine until the hierarchy changes in TM1.
Once that happens the reports break (meaning they don't pick up the element(s) that has changed).
Removing and adding back has been the only option for me.

However, I noticed one change in the MUN (Member Unique Name) that is different.
When I originally created the report the MUN was created differently for example
[5YR Actual Comparison].[Location].[Location]->:[TM].[Location].[Location].[@MEMBER].[881]
whereas the newly added elements MUN looks like this
[5YR Actual Comparison].[Location].[Location]->:[TM].[Location].[Location].[@MEMBER].[OPERATIONS DIVISION^885]

The newly added element include the hierarchy (OPERATIONS DIVISION), this is what is causing the reports to break.
Is there a way I to add the element into Report Studio without including the hierarchy?
Also, when I originally created the report why did it not include the hierarchy (which is good)

Thanks in advance guys.

Re: Hierarchy Changes affecting BI reports

Posted: Thu Mar 22, 2018 3:14 pm
by tm123
You need to execute RefreshMdxHierarchy after the Dimension Hierarchy changes.

Re: Hierarchy Changes affecting BI reports

Posted: Fri Mar 23, 2018 2:36 pm
by Reuben
ok thanks. Let me take a look

Re: Hierarchy Changes affecting BI reports

Posted: Wed Aug 01, 2018 3:38 pm
by venkat
HI Reuben,

Is it efreshMdxHierarchy(''); function working for you ?

Today i also faced same issue i am getting error like attached screen shot , Could you please reply .

Regards,
Tm1