4 Replies Latest reply: Jun 4, 2013 10:04 AM by Nasar-Oracle RSS

    not able to get sales data at the AWM - cube

    1010049
      Hi,

      I have Built my first cube and I am looking for sales data at AWM's cube viewer.

      I can drill down a hierarchy, but I cannot get any sales data at the cube, the cube was created on the product dimension(W_PRODUCT_D,W_PRODUCT_DH)s,Time (W_DAY_D) and sales fact.
      Defined levels are ...
      Product : All_Prod,SBU,Category,Sub Category
      Time : All, Year, Qtr,Month
      measures :Stored measures(Sales_val)

      I am using Analytic Workspace Manager Version 11.2.0.1.0.


      Does the AWM cube viewer shown data without any caleculated measure?

      Can anyone help me ? pls

      Thanks,
        • 1. Re: not able to get sales data at the AWM - cube
          Shankar S.-Oracle
          By default, cube viewer shows the default measure of the cube at the topmost levels of all dimensions along their default hierarchies.
          You have to use the Selector (Top Left icon, i think) to select a more relevant section (slice) of the cube via dimension selections or for other measures including other stored/calculated measures.

          Try to understand how the Selector works... dimensions are available via adrop down, further to dimension selection, you have a dimension-hierarchy drop-down.. Then you can select members at specific level or members which match a condition etc..

          Identify a specific row in source table (e.g month_id = 201305 with name= 'MAY-2013', prod_id = 575 with product name = 'ABC Cornflakes', say) and use selector to select the corresponding member (Time dimension .. select hierarchy and select lowest level MONTH, add condition for member matching pattern '%201305' or member name matching '%MAY-2013%' and product dimension.. select hierarchy, then lowest level and then condition for member matching pattern '%_575' or member name like '%ABC Cornflakes%' etc.

          HTH
          • 2. Re: not able to get sales data at the AWM - cube
            1010049
            Thanks for your reply,

            I have find the solution

            Thanks & Regards,
            rm
            • 3. How to add Actions to Agent in obiee 11g
              1010049
              Hi,

              I'm new for this Agents concept in OBIEE 11g,

              Pls any one help me ...

              how to give conditions in new agent creation?
              how to add existing action to agent?
              is there any option to change colour based on condetion ?(In alerts)
              how to use parameters in agents?

              Pls send related doc if you have..

              Thanks & Regards
              rm
              • 4. Re: How to add Actions to Agent in obiee 11g
                Nasar-Oracle
                OBIEE discussion forum is at:
                Business Intelligence Suite Enterprise Edition


                OBIEE User's guide at:
                http://docs.oracle.com/cd/E23943_01/bi.1111/e10544/toc.htm

                .