3 Replies Latest reply on Sep 5, 2012 4:18 PM by nasar.ali-khan at -Oracle

    How to calculate count of records

    user1299751
      I have a fact table with following columns:

      Invoice_no
      Date_key
      Product_key
      Sales
      Cost

      There are multiple lines for each invoice.

      I have created a AWM schema where I have a product dimension and Date dimension. Date dimension has year, month and day as one hierarcy.

      I have created a cube on this table with dimensions of date & product.

      The cube shows a summary by product as well as by date dimension. The last level of summary is based on a day. I would like to count the no of records which sum up in a day.

      For example, I need the count column in the following result set in the cube:

      Day--------------product---------sales--------Cost------Count
      01-jan-2010---Lays Chips-----20000------15000---20

      here count is the no of records which sum up to make 20000 value sales.

      what formula in AWM I have to use for this calculated measure.

      I am using AWM 11.2.0.1.0A