SEVERE: mondrian.olap.InvalidHierarchyException: Mondrian Error:Hierarchy

Answered
satishappa asked on March 2, 2017

How to resolve above exception "SEVERE: mondrian.olap.InvalidHierarchyException: Mondrian Error:Hierarchy '[Time].[Time]' is invalid (has no members) (in Hierarchy 'Time')"

5 answers

Public
Tanya Gryshko Tanya Gryshko Flexmonster March 2, 2017

Hi Satishappa!

Thank you for the question but it would be nice to know some details about your problem.

Regards,
  Tanya

Public
satishappa March 3, 2017

Hi Tanya,
 
When  we giving input of dimensions and measures this error comes up while loading PIVOT table.
 
Regards,
Satish

Public
Tanya Gryshko Tanya Gryshko Flexmonster March 3, 2017

Hi Satishappa!

Probably you have some problem with your schema. Could you please check if it's created correctly?

Regards,
  Tanya

Public
satishappa March 3, 2017

Hi.
We are using foodmart xml, From there only we are getting this issue.
 
Regards,
Satish

Public
Tanya Gryshko Tanya Gryshko Flexmonster March 3, 2017

Hello Satishappa,
Thank you for the explanation. However, we are unable to identify the cause of your problem. Could you provide us with more details? Have you tried to display the data from your cube using any other tools?
Regards,
Tanya

Please login or Register to Submit Answer