Guidance on defining a simple cube and report.

Question

Guidance on defining a simple cube and report.

Joy Smith San

SSC-Insane

Points: 24877
More actions
April 26, 2012 at 6:27 am

#259981

Experts,
Am new to SSAS and SSRS.
I have been asked to create a report with data source as cube (They want data source as Cube only).
The report format is something like below.
ProdutName Manufacturer Unit (Kg, Ltr etc;) SalesPerson Obsolete
Only these 5 fields are necessary, nothing else.
Ofcourse I have the following tables,
Product
Manufaturer
Unit
Salesperson
As far as I understand, I don't see a Fact table and measure here and confused how to define the cube.
Can anyone pls guide me to create this simple cube and report ?.
I have gone through some of the notes and have created some of teh cubes and reports.
Deployed and using the same. Also I am aware that the above report can easily be created using a simple query. But the requirement is it must be based on cube.
Thanks in advance,
Smith.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 1

No replies at all......... Unfortunate.

Please see the attached snapshot. Basically what I want is I DO NOT want to display the last column "Computer Count" which is a measure. But I don't add this column then I am not getting any records as well. I want the fields only from "Add Remove Programs" dimension.

Can anyone guide me how to go about it.

Thanks,

Smith.

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 2

It seems the person making the requirements has no idea what a cube is.

A cube is made to aggregate data (aka measures) and look at those measures from various viewpoints (aka the dimensions).

Without measures, a cube is utter useless and - as you have found out yourself - it is much easier to just create a SQL query.

Anyway, things are what they are, so just create a bogus measure - that count will do just fine - include it in your query so that you have your data and create your report. At the end, hide the column containing the measure. Everybody happy 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 3

Thanks for the reply.

Yes, I did exactly the same actualy. I din't include that last column in report.

Wel the reason why they are asking is, since the data is huge they want to process the data once in 2 days or some and generate reports based on it. 2 days old data is quite OK for them.

Now I find it little diffclt to exclude some 50 specific application names from it.

Bit confused on how to filter it out.

Thanks a lot again.

Smith.