2 Replies Latest reply: Aug 15, 2013 12:43 AM by User777940-Oracle RSS

    How to use/set CALCULATEDMEMBER

    User777940-Oracle

      Hi

      I'm useing  OBI11.1.1.6.8 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

       

      Thanks

        • 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
            User777940-Oracle

            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.

            Thanks

            Shane