Excel MDX Error

[former_member192811]

Hello Everyone,

I have Hdbstudio 1.0 rev 70.

I have created a basic calculation view which simply fetches data from one of the tables in my schema to which I have already granted SYS_REPO.

I can successfully activate and do a data preview for this view.

In excel I can successfully test MDX connection .

However when  I select  this calcualtion view to show data as pivot report I get the following error.

Kindly help .

Regards,

Pooja M.

[former_member182302]

Is HIERARCHY_VIEW , a hierarchy defined in your view?

Regards,

Krishna Tangudu

[former_member192811]

Nope its a simple calculation view. I am not sure if its defined in some other sub-package.

Atleast my package doesn't have it.

I have tried viewing other views in other  sub packages too and the error is same throughout.

Regards,

Pooja M