ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

ReportPortal General Forum

Report Portal General Issues

Showing inline related attributes

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

Smilies

[quote][i]Originally posted by dbooth[/i]
[br]This may be an SSAS issue, apologies if so.  An OLAP report contains a Customer dimension, with Customer Number and Customer Name as columnar attributes, like so :

Sales Territory - Country - Customer Number    -   Customer Name  -   Revenue

The initial display is aggregations at the All level, and users can break through to e.g. Sales Territory 'EU', Country 'GB', and then explode the Customer attribute.

At that point it would be nice for the Customer Name attribute to show inline against each Customer Number :

Sales Territory - Country - Customer Number - Customer Name - Revenue

EU                All       All               All             12345  
EU                BE        All               All              1234 
EU                GB        ABC123            A Customer        123
EU                GB        BCD234            Someone Else       12

Hope the table is readable.

As it is, the Customer Name needs to be opened for each Customer Number, which impedes legibility.

It is possible to create a report that shows the detail right away, but that doesn't show aggregations at the All level.

Is the inline display of related attributes feasible (e.g. show Customer Name inline with Customer Number when the latter is exploded from the All level)?
[/quote]

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
dbooth	Posted - 01/20/2012 : 04:59:16 This may be an SSAS issue, apologies if so. An OLAP report contains a Customer dimension, with Customer Number and Customer Name as columnar attributes, like so : Sales Territory - Country - Customer Number - Customer Name - Revenue The initial display is aggregations at the All level, and users can break through to e.g. Sales Territory 'EU', Country 'GB', and then explode the Customer attribute. At that point it would be nice for the Customer Name attribute to show inline against each Customer Number : Sales Territory - Country - Customer Number - Customer Name - Revenue EU All All All 12345 EU BE All All 1234 EU GB ABC123 A Customer 123 EU GB BCD234 Someone Else 12 Hope the table is readable. As it is, the Customer Name needs to be opened for each Customer Number, which impedes legibility. It is possible to create a report that shows the detail right away, but that doesn't show aggregations at the All level. Is the inline display of related attributes feasible (e.g. show Customer Name inline with Customer Number when the latter is exploded from the All level)?
3 L A T E S T R E P L I E S (Newest First)
admin	Posted - 01/24/2012 : 01:19:26 Yes, just drag and drag Dimension attributes to measures. Please see "Olap Report\ Dimension attributes" report on the demo server: http://www.reportportal.us
dbooth	Posted - 01/24/2012 : 01:12:42 Is it possible to combine a hierarchy and dimension attributes in one report layout? In the example, the Sales Territory/Country/Customer would be in a hierarchy, and the Customer Name a dimension attribute. When doing this with the cube I have built, the All level of the Territory attribute is shown, with every possible value for the Customer Name, like so : Sales Territory - Country - Customer - Customer Name - Revenue EU - All - All - A Customer - 123 - Someone Else - 12 The desired result is for Customer Name only to show when the Customer attribute is expanded.
admin	Posted - 01/20/2012 : 08:42:07 To remove the All level from a dimension please select a level instead of the entire dimension hierarchy. http://www.reportportal.com/help/olap/report.htm

ReportPortal