2 Replies Latest reply on Aug 15, 2013 5:43 AM by Takurit-Oracle

    How to use/set CALCULATEDMEMBER



      I'm useing  OBI11. and I want to use CALCULATEDMEMBER.

      But I'm not sure how to use this CALCULATEDMEMBER.

      Dose anyone knows how to use/set CALCULATEDMEMBER

      Could you give me a sample using “Sample Sales Lite”?


      - Document   http://docs.oracle.com/cd/E23943_01/bi.1111/e10540/sqlref.htm#BIEMG664  

      - Blog   http://www.rittmanmead.com/2010/08/oracle-bi-ee-11g-new-bi-server-functions/


      Hope to hear some information



        • 1. Re: How to use/set CALCULATEDMEMBER
          Sasi  Nagireddy

          Calculated members are user-defined dimension members whose measure values are calculated at run time. You can define a calculated member within a dimension through a formula that references other members of the same dimension.

          These are also used in Parent -Child Hierarchies:-

          CALCULATEDMEMBER("HR"."Employee"."EmployeeDim",'Test', MEMBER(100) - MEMBER(101) -MEMBER(102))

          Mark if helps.

          • 2. Re: How to use/set CALCULATEDMEMBER

            Hi Mark

            Thank you for your update.


            I'm sorry to bother you when you are busy.


            CALCULATEDMEMBER("HR"."Employee"."EmployeeDim",'Test', MEMBER(100) - MEMBER(101) -MEMBER(102))

            This one must be use HR schema, I tried to use HR schema and create above but I cannot find "EmployeeDim".

            I guess I should create "EmployeeDim" but I'm beginner of BIEE. So I'm not sure how to create this.

            Could please let me know how to set/use CALCULATEDMEMBER with HR schema?

            Or please let me know any documents

            Any comments are welcome.