Ranking : Show only two rows in each line break

building reports desktopintelligence
1

Hi,

In DESKI reports, I am having only two dimension objects and no any measures.

For Ex:

Country State

USA Arizona
USA Atlanta
USA California
USA Chicago
USA Florida
USA Los Angels
USA Miami

India Assam
India Bihar
India Chandigarh
India Delhi
India Gujarat
India Kerala

UK England
UK Ireland
UK Scotland
UK Wales

UAE Abu Dhabi
UAE Dubai
Now i want the report like the below one.

Country State

USA Arizona
USA Atlanta

India Assam
India Bihar

UK England
UK Ireland

UAE Abu Dhabi
UAE Dubai

Please anybody can help me

Thanks and Regards,
Sridhar

s.sridhar :india: (BOB member since 2010-04-22)

2

Hi,

Make new measure object with below code in universe :

Row_Number() over(partition by Country order by State)

Use this object in ur query …
Then Apply rank 2 on New Universe Object.

Hope This will serve ur purpose …

Thanks & Regards
Pravin G.

pravin_gaikwad :india: (BOB member since 2010-03-27)

3

Hi Pravin,

Thank You.

Is that possible to solve the issue, without creating any measure object in the universe level.

Thanks & Regards,
Sridhar

s.sridhar :india: (BOB member since 2010-04-22)