function topcount in dimensional model?

[sergiord2016]

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!!

[Lynn]

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

[sergiord2016]

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...