Please suggest the idea for making reports

Question

Please suggest the idea for making reports

srinadh.ramineni

Say Hey Kid

Points: 675
More actions
June 9, 2011 at 10:25 pm

#389702

Hi to all,
I want to make some reports on a dimensional model not in a cube. Client doesn't want to build the cube, but he wants to make the reports from the data mart what we created.
And also keep in mind that, the 2nd phase of the project is having the cube implementation. So please suggest me what is the right idea for making the reports on a data mart.
Thanks and Regards,
Srinadh.

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

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

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 1

There is no "right" idea. What tool / software are you using for reporting?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

srinadh.ramineni Say Hey Kid Points: 675 More actions · Answer 2

Hi,

I am using Microsoft BI (SSAS, SSIS and SSRS) software for thie above requirement.

Srinadh.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Which is it you don't want a cube?

I want to make some reports on a dimensional model not in a cube.

But the second phase of the project requires a cube?

the 2nd phase of the project is having the cube implementation.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

srinadh.ramineni Say Hey Kid Points: 675 More actions · Answer 4

My Requirement is:

I have a OLTP database, using this i should create a dimensional model (Star or Snowflake schema). Using this model i should give some reports using SSRS.

NOTE: Cube is second phase requirement not the current requirement. Now the first phase development is going on.

Srinadh.

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 5

srinadh.ramineni (6/12/2011)
My Requirement is:
I have a OLTP database, using this i should create a dimensional model (Star or Snowflake schema). Using this model i should give some reports using SSRS.
NOTE: Cube is second phase requirement not the current requirement. Now the first phase development is going on.
Srinadh.

Given the first statement, I would say you need the cube before you can do the reports. The reports are supposed to come off the cube.

EDIT: At least, in my experience, that's what the wording of what you posted means. If your client means otherwise, then I think he wants a data warehouse or operational data store, which would be a flattened db, not a Star or Snowflake schema db. I don't see the use of a Star or Snowflake schema in a basic reporting db and it just makes things more complicated.

This very much sounds like a case of a client who doesn't know what he really wants and is just asking for the moon and the stars (and using technical terms he doesn't understand) in the hopes of getting everything.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.