Hi ,
How can i make a topcount in dimensional model?
I mean , i can do it in relational model , for example topCount([BBDD_T].[LK_FACT_HOSPITALES].[ABREVIATURA];10;[IMPORTE])
Is there any dimensional function to select the top 10 values?
thank you!!
Quote from: sergiord2016 on 12 Apr 2017 05:13:37 AM
Hi ,
How can i make a topcount in dimensional model?
I mean , i can do it in relational model , for example topCount([BBDD_T].[LK_FACT_HOSPITALES].[ABREVIATURA];10;[IMPORTE])
Is there any dimensional function to select the top 10 values?
thank you!!
topCount is a dimensional function. Rank is typically used for similar functionality with relational sources although sometimes dimensional functions will work when using a crosstab or chart layout container.
Refer to Appendix F, Dimensional Functions in the report studio user guide. This link also shows dimensional functions: https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.0/com.ibm.swg.ba.cognos.ug_md.10.2.0.doc/c_dimensional.html
Quote from: Lynn on 12 Apr 2017 05:32:54 AM
topCount is a dimensional function. Rank is typically used for similar functionality with relational sources although sometimes dimensional functions will work when using a crosstab or chart layout container.
Refer to Appendix F, Dimensional Functions in the report studio user guide. This link also shows dimensional functions: https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.0/com.ibm.swg.ba.cognos.ug_md.10.2.0.doc/c_dimensional.html
Thank you , i thought topcount was a relational function...