Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
9 replies Latest Post - ‏2013-02-01T16:57:41Z by SystemAdmin
coolcognos
coolcognos
91 Posts
ACCEPTED ANSWER

Pinned topic rank in crosstab with two dataitems

‏2013-01-28T13:19:02Z |
Hi,

My Requirement is like below in crosstab.

name total product name
count Count
product type
type1
type2
typen
top 100 count based on product type....
need help

Thanks & Regards
cognosbi
Updated on 2013-02-01T16:57:41Z at 2013-02-01T16:57:41Z by SystemAdmin
  • DanielWagemann
    DanielWagemann
    411 Posts
    ACCEPTED ANSWER

    Re: rank in crosstab with two dataitems

    ‏2013-01-28T14:24:48Z  in response to coolcognos
    Are you using an OLAP,DMR or relational package?
    • coolcognos
      coolcognos
      91 Posts
      ACCEPTED ANSWER

      Re: rank in crosstab with two dataitems

      ‏2013-01-28T14:37:03Z  in response to DanielWagemann
      i am using OLAP
    • coolcognos
      coolcognos
      91 Posts
      ACCEPTED ANSWER

      Re: rank in crosstab with two dataitems

      ‏2013-01-28T14:44:42Z  in response to DanielWagemann
      Relational Package
      • DanielWagemann
        DanielWagemann
        411 Posts
        ACCEPTED ANSWER

        Re: rank in crosstab with two dataitems

        ‏2013-01-28T15:53:11Z  in response to coolcognos
        Alright, let's try this again.... Are you using a relational package or an OLAP package?
        • coolcognos
          coolcognos
          91 Posts
          ACCEPTED ANSWER

          Re: rank in crosstab with two dataitems

          ‏2013-02-01T09:53:57Z  in response to DanielWagemann
          Relational Database.....
          • DanielWagemann
            DanielWagemann
            411 Posts
            ACCEPTED ANSWER

            Re: rank in crosstab with two dataitems

            ‏2013-02-01T14:08:49Z  in response to coolcognos
            Have a look at the attached 10.1.1 example which goes against the Go Sales(query) relational package. It cheats a bit by using the OLAP filter function on the edge of the crosstab but it gets the job done.

            filter([Sales (query)].[Product].[Product type],rank([Quantity])>10)
            


            If this is not what you are looking for, please put together a samples crosstab which further explains your requirement.
            Updated on 2014-03-25T07:43:19Z at 2014-03-25T07:43:19Z by iron-man
            • SystemAdmin
              SystemAdmin
              15496 Posts
              ACCEPTED ANSWER

              Re: rank in crosstab with two dataitems

              ‏2013-02-01T14:56:24Z  in response to DanielWagemann
              Hi Daniel,

              I have quick question relate it to this query. Since we are dealing with relational data I thought we can't use OLAP function such as "Filter" or mix OLAP function with relational function. I am bit confuse.

              Thanks,
              Winson.
              • DanielWagemann
                DanielWagemann
                411 Posts
                ACCEPTED ANSWER

                Re: rank in crosstab with two dataitems

                ‏2013-02-01T16:39:03Z  in response to SystemAdmin
                That is the part that cheats... a crosstab spins a cube object behind the scenes which may allow you to use certain OLAP items. Just like when you click on a measure and hit summary ... it creates an OLAP style total even though its a relational data source.