Topic
  • 9 replies
  • Latest Post - ‏2013-02-01T16:57:41Z by SystemAdmin
coolcognos
coolcognos
91 Posts

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

    Re: rank in crosstab with two dataitems

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

    Re: rank in crosstab with two dataitems

    ‏2013-01-28T14:37:03Z  
    Are you using an OLAP,DMR or relational package?
    i am using OLAP
  • coolcognos
    coolcognos
    91 Posts

    Re: rank in crosstab with two dataitems

    ‏2013-01-28T14:44:42Z  
    Are you using an OLAP,DMR or relational package?
    Relational Package
  • DanielWagemann
    DanielWagemann
    411 Posts

    Re: rank in crosstab with two dataitems

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

    Re: rank in crosstab with two dataitems

    ‏2013-02-01T09:53:57Z  
    Alright, let's try this again.... Are you using a relational package or an OLAP package?
    Relational Database.....
  • DanielWagemann
    DanielWagemann
    411 Posts

    Re: rank in crosstab with two dataitems

    ‏2013-02-01T14:08:49Z  
    Relational Database.....
    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

    Re: rank in crosstab with two dataitems

    ‏2013-02-01T14:56:24Z  
    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.

    <pre class="java dw" data-editor-lang="java" data-pbcklang="java" dir="ltr">filter([Sales (query)].[Product].[Product type],rank([Quantity])>10) </pre>

    If this is not what you are looking for, please put together a samples crosstab which further explains your requirement.
    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

    Re: rank in crosstab with two dataitems

    ‏2013-02-01T16:39:03Z  
    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.
    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.
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: rank in crosstab with two dataitems

    ‏2013-02-01T16:57:41Z  
    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.
    Thanks Daniel for the detail explanation.