| Author |
 Topic  |
|
|
Esther
Switzerland
3 Posts |
 Posted - 07/01/2009 : 06:41:07
|
Hello
I am currently creating OLAP reports for a customer who wants multiple column headings, such as
Main column heading (EUROPE)
is further subdivided into second level column headings (GERMANY, FRANCE, GB, etc.)
each of those is further divided into columns (GERMANY REGION 1, GERMANY REGION 2, FRANCE REGION 1, FRANCE REGION 2, FRANCE REGION 3, GB REGION 1, etc.)
followed by the actual data underneath.
How do I implement something like this in report portal? The old reports used to be in Excel so it was easy enough to implement. The headings are just text and not linked to the data. The data is not grouped like this in the cube.
Thanks in advance for your help
Esther
|
|
|
admin
1643 Posts |
Posted - 07/02/2009 : 00:10:33
|
| Have you tried to drag your Continent, Country, Region levels from the field list to columns? |
 |
|
|
marco
Netherlands
588 Posts |
Posted - 07/02/2009 : 02:32:04
|
Just drag and drop the dimension attributes (country, Area, etc) into the column area of your report and that is all there is.
Regards,
Marco
www.gmsbv.nl
|
|
|
|
Esther
Switzerland
3 Posts |
Posted - 07/07/2009 : 00:07:42
|
First of all, thank you for your quick response to my problem.
The (simplified) example I used in my original posting I only used to illustrate the problem. Unfortunately I do not have dimension data/attributes in my cube that solve my problem. The customer wants several columns (calcuated measures) to be grouped with some kind of descriptive heading to structure the report more clearly. The column headings are already very long. Any thoughs on how this could be done or if this can be done? I am fairly new to this tool and have not done a lot of work with it. Can my problem be solved using names sets or shared calculated measures? Can it be solves at all?
Thanks
Esther
|
|
|
|
marco
Netherlands
588 Posts |
Posted - 07/07/2009 : 11:54:17
|
Hi,
Please make a sample report in Excel with the names, columns, rows and some sample data and email me this to info at gmsbv.nl.
I will see what you would like to have and if this is possible and what you need to have this possible.
Marco |
|
|
|
admin
1643 Posts |
Posted - 07/08/2009 : 20:07:09
|
Grouping of attributes should be possible on the SSAS server side by create a grouping attribute. For example, in US you have 50 states. If you want to group them into four regions (NW, NE, SE and SW) you just create a new column in the customer dimension called Region and expose it as an attribute in SSAS.
Doing this with MDX (creating calculated members using Aggregate function) is very difficult, will require ongoing maintenance and will not produce nice visual results. |
|
|
|
Esther
Switzerland
3 Posts |
Posted - 07/14/2009 : 11:19:05
|
Thank you both for your help. I think I got something I can work with now.
Thanks
Esther |
|
|
| |
Topic |
|
Report Portal
Report Formatting
