I have a straight table with multiple dimensions and measures .how to generate a dimension with numbers(1-100) how to get in ui level.

[#1]

I have a straight table with multiple dimensions and measures .how to generate a dimension with numbers(1-100) how to get in ui level.

[settu_periasamy]

Hi,

is there any purpose to add the row number in dimension?

if you just want to show the row number,

put the RowNo(TOTAL) in Expression, Move it to Dimension side.

Not good. But ok. 🙂

[Qrishna]

You can use in dimension also. like a calculated dimension.

If you got the answer please close the thread as answered.

Thanks

[settu_periasamy]

I think, we can't use the RowNo() as a Calculated Dimension.

[#5]

Hi Krishna,

    Please Give the Screen shot...the attached file can't open in my system.

Thanks & Regards

Jammula

[Qrishna]

I guess we can.

try writing =Aggr(only(id),name) in your chart.

in script,put

rowno() as id.

[Qrishna]

load *,

rowno() as id;

load * inline [

name,sal

kiran, 40

naresh, 20

raja, 10

raju, 50

suresh, 30

];

[Qrishna]

Any luck?