COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: cognos4321 on 13 Jun 2016 04:04:23 PM

Title: Error in BI report sorcing from TM1 Cube, works fine in Dev enviornment
Post by: cognos4321 on 13 Jun 2016 04:04:23 PM
Hi experts,

I am running a report in report studio and it works absolutely fine in Development environment and shows the following error in Production

Identifier not found '[Planning].[Account].[Account].[L4]'.

We are using cognos 10.2 and the source for all reports is TM1 cube.
I guess there is some issue with alignment of cubes in Dev and prod since the report works fine in Dev.
I checked the }HierarchyProperties Cube and was able to see all the dimensions used . I clicked Show all---> OK in both the environments in }HierarchyProperties Cube but still the error remains the same. I don't know if I am following a correct approach.

Please suggest something to troubleshoot this issue

Thanks Always.
Title: Re: Error in BI report sorcing from TM1 Cube, works fine in Dev enviornment
Post by: MFGF on 14 Jun 2016 04:20:32 AM
Quote from: cognos4321 on 13 Jun 2016 04:04:23 PM
Hi experts,

I am running a report in report studio and it works absolutely fine in Development environment and shows the following error in Production

Identifier not found '[Planning].[Account].[Account].[L4]'.

We are using cognos 10.2 and the source for all reports is TM1 cube.
I guess there is some issue with alignment of cubes in Dev and prod since the report works fine in Dev.
I checked the }HierarchyProperties Cube and was able to see all the dimensions used . I clicked Show all---> OK in both the environments in }HierarchyProperties Cube but still the error remains the same. I don't know if I am following a correct approach.

Please suggest something to troubleshoot this issue

Thanks Always.

It sounds to me like the L4 member exists in your Dev cube but not in your Prod cube? If you're referring directly to this in your report, it makes sense that it will work in Dev but not in Prod...

MF.
Title: Re: Error in BI report sorcing from TM1 Cube, works fine in Dev enviornment
Post by: cognos4321 on 14 Jun 2016 08:55:55 PM
Thanks MF for the reply.
It's fixed now . I had to update hierarchies in the Hierarchy properties cube in prod.