Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Unable to query an Essbase cube that uses [ ] brackets within member names

Received Response
1
Views
2
Comments
3244789
3244789 Rank 1 - Community Starter
edited Aug 13, 2024 6:18PM in Oracle Analytics Cloud and Server

Hi Oracle team,

I am using EssbaseBridge.dll for running different MDXQueries, but I am not able to create MDX Queries with members that start and end with brackets in their names. For example: "[MemberName]".

I Succeeded to manage members that only start (and not end) with brackets, by double the close brackets. For example: "[Parent].Child" - this member could be used in MDX query like: "[[Parent]].Child]". This rule doesn't work for members that I mentioned above.

Thank you in advance,

Vitalie Semenciuc

Software Developer

IBM Romania

Answers

  • krikumar-Oracle
    krikumar-Oracle Rank 1 - Community Starter

    Essbase does not support brackets [ ] in the alias name, as it is used in determining non-unique members in MDX queries, and is a reserved character. Do not use brackets [ ] in alias names in the Essbase outline.

  • 3244789
    3244789 Rank 1 - Community Starter

    Thank you very much for your answer, Krish.

    Also, I would like to ask you how can I obtain bulk, using EssbaseBridge.dll, all the hierarchy of the members from a cube. Currently I run a new query for each parent in order to obtain its children.

    Can I load all the hierarchy of members with one method, without running a query for each parent in order to obtain its children ?

    Thank you in advance,

    Vitalie Semenciuc

    Software Developer

    IBM Romania