Skip to Content

Excel MDX Error

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 .


Pooja M.

pastedImage_0.png (24.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 28, 2014 at 10:38 AM

    Is HIERARCHY_VIEW , a hierarchy defined in your view?


    Krishna Tangudu

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.


      Pooja M

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.