2 Replies Latest reply: Dec 26, 2012 10:10 AM by CL RSS

    Essbase issue


      We have ASO cube where in one dimension has approx. 50k members which are stored and shared. I need to see all the shared members of the dimension separately.
      Is there any option using which we can see all stored/shared members of a dimension as it is practically impossible to go to each member and check the Data storage of each property.

      Thanks in advance,
        • 1. Re: Essbase issue
          EPMA allows you to extract the dimensions if it is in fact an EPMA enabled application.

          Otherwise, I would suggest using AppliedOlap's outline extractor.
          • 2. Re: Essbase issue
            I believe you can also use MaxL's dimension extract:

            You will have to craft an XML to SQL (or whatever) routine. There are lots of examples out there.


            Cameron Lackpour