ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
memux	Posted - 05/31/2010 : 17:56:52 Guys, friends, i have a problem with sorting in the olap report, i can sort by columns, but i dont know how sort in columns and rows at the same time, Ex: This is the Olap Report (i have this) ProdA ProdB ProdC Customer A 100 20 40 Customer B 80 40 30 Customer C 120 180 140 This is the Olap Report sorting by rows and columns( I want this) ProdB ProdC ProdA Customer C 180 140 120 Customer B 40 30 80 Customer A 20 40 100 With the report portal can do that??? Thanks for you helping. Memux!
3 L A T E S T R E P L I E S (Newest First)
admin	Posted - 06/03/2010 : 06:35:22 Yes, the only way to sort column members based on a row is to switch axis.
memux	Posted - 06/02/2010 : 10:46:05 ok, only to confirm, the only way to sort is to pivot the grid, or build a new olap report with the new view, Move dimensions on rows to columns and those on columns to rows. or click the button is switch axis. The Help in RP says Pivot = Move dimensions on rows to columns and those on columns to rows. I'm right? Thanks Memux!
admin	Posted - 06/02/2010 : 03:36:19 It seems that you want to sort Product placed on Columns based on first row (row-measure tupple) value. The only way to this is to pivot the grid.

ReportPortal