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

    Essbase issue

    847750
      Hi,

      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
          MattRollings
          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
            CL
            I believe you can also use MaxL's dimension extract:
            http://docs.oracle.com/cd/E17236_01/epm.1112/esb_tech_ref/maxl_expotl.html

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

            Regards,

            Cameron Lackpour