Problem when a try to make "RCOUNT(DIMENSION_EXAMPLE)" WITH UNI

Question

Hi guys!

Me Again

I Need some help to make this formula  RCOUNT() when a have "ton of Columns"  i need give a "position" on the LINE of a PIVOT TABLE.

This is a UNION (two equal cubes) and this is a  new calculated field on presetation layer.

No matter what i do, never work in a UNION state, in simple CUBE work well.

Why i Need do this?

Simple! To put a position in a column: ( like this example on EXCEL )

Anyone please, help-me

Best Reggards from Brazil  \o/

André-Nogueira · Answer

Hello Cholas!

Thanks a lot, for trying help-me but i figure how do this.

My Dashboards are too "overpowers" with a lot of dimension, ( 20+) i am trying to make more clean, with some features like  "click and go"  because the performance, are too hard to run some dashboards, (Years of Year is a good exemple ) my company have 65 Years of database of our's stores it is a MASSIVE database.

I Push hard the "sql tuning" to make more easy to run on presetation layer this datas.

asim cholas · Answer

what is the results you are getting now in pivot?

André-Nogueira · Answer

No one ?