1 2 3 4 Previous Next 54 Replies Latest reply: Jul 16, 2013 4:46 PM by Nasar-Oracle Go to original post RSS
      • 30. Re: how to do a count distinct value in awm
        580180
        Hi Nirav,

        Please let me know your mail id and I will send over the documents.

        Thanks,
        Piyush
        • 31. Re: how to do a count distinct value in awm
          683101
          Hi Piyush,
          My email ID is nirdeep6@yahoo.com

          Thanks for responding. Looking forward to hearing from you. More over the email.

          Nirav
          • 32. Re: how to do a count distinct value in awm
            627034
            Hello, can you also please explain to me how I can do this:

            We are using Oracle 10g Enterprise Edition Release 10.2.0.4.0 - 64bit with OLAP

            For the commercial reporting and we have 2 non-additive measures for the product and store dimensions: number of debits, number of clients (f.e. you can go twice a month in a store ) and some volume 120.000.000/months for the detail level (day/store/client/debit/product). We are using a “count distinct” but the user can’t drill and must wait a long time for each request.


            We have the following dimensions:

            Store : All -> Business Unit (4) -> Area (50) -> Store (600) (-> Desk -> Ticket header in order to calculate de debit)
            Client : All -> segment (10) -> Account (2.000.000)
            Product : All –> Universe (6) -> “métier” (40) -> Category (350) -> … -> Product (500.000)
            Time : Year (3) -> Semester (6) -> Quarter -> (12) -> Month (36) -> … -> Day (1.100)


            We want to build a cube will with <Store, Segment, Category, Month> as basis level. We have already a prototype (we use AWM) with the additive measure like Turnover (Historical, Budget, Actual>, Quantity Sold (H,B,A) but we don’t known how we can manage the Number of Debits (count distinct of ticket header) and the number of account (count distinct of account). The count distinct must be evaluated for each level in a dimension. The debits are additive belong the Store dimension.

            I have seen that you have a document that explains how to manage COUNT DISTINCT measures within OLAP. Can you send me this information?

            frank.vanimschoot "at" businessdecision.com

            Thanks,

            Frank
            • 33. Re: how to do a count distinct value in awm
              Kirill.Boyko
              Hello Piyush!

              Sorry for bothering, but I'm facing same problem!
              Could you please share this knowledge.

              k.boyko@auchan.ru

              Looking forward to hearing from you!

              Regards,
              Kirill Boyko
              • 34. Re: how to do a count distinct value in awm
                535867
                Good day all!

                As it happens, I am also struggling with similar issues. The count(distinct()) in general seems to be a real pain. Could someone send the aforementioned documents to me also?

                My email is:
                erik.forsstrom@gmail.com

                Thank you!

                Regards,
                Erik
                • 35. Re: how to do a count distinct value in awm
                  688991
                  Hi,

                  I have two dimensions and one fact table and I want to build a cube with a measure as
                  "COUNT(*)" from the fact table. How to do that within AWM?

                  Thank you

                  My email is:
                  m.t.tran@web.de

                  Edited by: user10411795 on 04.03.2009 04:56
                  • 36. Re: how to do a count distinct value in awm
                    580180
                    Hello Nirav / Frank / Krill / Erik / User10411795,

                    I am sorry for the long delay in replying to this thread.

                    Due to an extreme personal emergency, I have been out of action for a few weeks - and still trying to catch up on the missed items.

                    I have mailed you all the required documents at the e-mail ids that you mentioned in this thread.

                    Hope it helps.

                    Best Regards,
                    Piyush
                    • 37. Re: how to do a count distinct value in awm
                      Klaker-Oracle
                      In an attempt to protect Piyush's email Inbox from exploding with requests for this information we are hoping to post an article on the blog about how to manage count type measures. It should be available shortly. Thanks to Piyush for kindly sending out the documents which I thought I had lost - amazingly I have now found them again on an old zip drive.

                      Keith
                      • 38. Re: how to do a count distinct value in awm
                        688991
                        Hi,

                        I am again...

                        I have two dimensions and one fact table and I want to build a cube with a measure as
                        "COUNT" instead of "SUM".

                        Oracle Support Service told me:

                        - Create a formula that returns a 1 if a value is stored, otherwise returns zero.
                        - Then assign the values from this formula to a stored variable that can then be aggregated to reflect
                        the cells loaded.

                        But how can I do that with the AWM tool?

                        I need help!

                        Thank you!
                        Tran
                        • 39. Re: how to do a count distinct value in awm
                          727486
                          Hi Keith

                          Could you please send me the documents and ppt that explains how to create and manage count(distinct) measure using AWM and OLAP DML.

                          My mail id is rohit_s04@hotmail.com

                          We are using Oracle 11.1.0.7 and AWM 11.2.0.1.0

                          Regards
                          Yogesh

                          Edited by: user824647 on 12-Oct-2009 09:32
                          • 40. Re: how to do a count distinct value in awm
                            732905
                            Hi Keith,

                            Could you please send me the documents and ppt that explains how to create and manage count(distinct) measure using AWM and OLAP DML.

                            e-mail : mustafayalcin@yahoo.com

                            Regards
                            Mustafa

                            Edited by: user6402966 on Nov 9, 2009 1:51 AM
                            • 41. Re: how to do a count distinct value in awm
                              732905
                              Hi Keith,

                              Could you please send me the documents and ppt that explains how to create and manage count(distinct) measure using AWM and OLAP DML.

                              e-mail : mustafayalcin@yahoo.com

                              Regards
                              Mustafa
                              • 42. Re: how to do a count distinct value in awm
                                643970
                                Hi Keith,

                                Could you please send me the documents and ppt that explains how to create and manage count(distinct) measure using AWM and OLAP DML.

                                e-mail : vc_pani@yahoo.co.in

                                Thanks a Lot !!
                                Chakri
                                • 43. Re: how to do a count distinct value in awm
                                  SPowell42
                                  Could someone also forward a copy of the documents over to me? I'm working on an HR based data mart (relational) that is suffering performance issues due to all the count(distincts) we have to do...finding a solution in OLAP would be wonderful.

                                  The first part of my email address is "SPowell"
                                  The tail part of my email address is "@columbus.rr.com"

                                  Thanks very much in advance!
                                  Scott
                                  • 44. Re: how to do a count distinct value in awm
                                    739590
                                    Hi Keith,
                                    I have posted a threat earlier cos I didn't see this. I am having similar problem of counting. Could you also send me that documents.
                                    tashi_peldon@yahoo.com
                                    I have emailed you from my mail id as well.

                                    Many thanks
                                    tash