October 25, 2010 at 3:11 am
Hi all,
First of all I'm pretty new to SSAS and SSRS. And I'm a bit uncomfortable with the SSRS query-designer (because it gets SSAS data only in two dimension?!?).
What I have:
A SSAS Cube with dimensions and measures and data.
One Dimension is a hierarchy:
Customers
-main-groups
--detail-groups
One detail-group is assigned to every customer. And the detail-groups are categorized into five main-groups. But the main-groups itself contain no data (only the sum of their detail-groups).
What I want:
Now I want to create a SSRS report in BIDS. But I only want to display the main-groups. In the query-designer I can select only the main-groups, but I get not results (since they do not have any data because the data is in the detail-groups).
Question:
Do I have to group those detail-groups in the report or is there a direct way to get the aggregated (and only the aggregated) data?
Thx for any help
Reto E.
October 25, 2010 at 5:49 am
Well, another question:
How do I use the group filter with "in" in BIDS?!?
If I filter: [custgroup] = 1 - direct sales
or: [custgroup] = 2 - internet sales
the filter works.
But if I filter with "in":
[custgroup] in 1 - direct sales, 2 - internet sales
I get no results.
I guess I use the wrong sytax for the listing?
Thanks
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply