Microsoft Business Intelligence Project Booster Kit

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Siddharth Mehta » Microsoft Business Intelligence Project...

24 posts, Page 1 of 3

1 2 3 »»»

Microsoft Business Intelligence Project Booster Kit

Rate Topic

Display Mode

Topic Options

Author

Message

Siddharth Mehta

Posted Tuesday, November 24, 2009 12:03 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, March 13, 2011 4:45 AM
Points: 18, Visits: 94

Comments posted to this topic are about the item Microsoft Business Intelligence Project Booster Kit

Post #823701

SBS-291204

Posted Tuesday, November 24, 2009 3:39 AM

SSC Journeyman

Group: Administrators
Last Login: Friday, May 10, 2013 4:45 AM
Points: 77, Visits: 1,276

Mate, I think you'll find Jamie Thomson is a man... unless he's not telling us something?

Post #823752

Siddharth Mehta

Posted Tuesday, November 24, 2009 4:19 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, March 13, 2011 4:45 AM
Points: 18, Visits: 94

I came to know that just before 1 month. But this article was submitted long before that. My apollogies for the same. Pardon me Jamie, you can beat me up for that during the User Group meeting on 26th Smile

Post #823763

giovi

Posted Tuesday, November 24, 2009 4:34 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, June 01, 2010 4:29 AM
Points: 10, Visits: 34

Hi siddarth,

couple of things captured my interest:
- creating stored procedures for reports; is this wise in a MS BI environment? with a datawarehouse and cubes, one of things I found out best to use is a 3rd party report/analysis tool which truly uses the cubes. This saves a lot of effort; there is pretty much stuff, MS gold partners out there, delivering things at the level of pro-clarity
- documentation; although the product is not at the level to show full interdependancies, the BI documenter will be of use to many
- use the metadata fields in the database, as well descriptions in cube dimensions to extract them with automated tools

Post #823769

Siddharth Mehta

Posted Tuesday, November 24, 2009 4:50 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, March 13, 2011 4:45 AM
Points: 18, Visits: 94

I agree. When one has the leisure of purchasing licenses of 3rd party tools, one can always do that.
I have just tried to list tools that incurrs no cost.

Also using of stored procedures is/was required in the 2005 SSRS version. Even in DW environments, operational reporting can be a requirement when one wants to compensate for real time refresh of data from cubes. Cubes generally are refreshed at specific intervals, and the data generally changed during those intervals is facilitated thru operational reporting using operational reports right from the OLTP system.

This is my viewpoint. Thanks for your feedback.

Post #823775

giovi

Posted Tuesday, November 24, 2009 4:57 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, June 01, 2010 4:29 AM
Points: 10, Visits: 34

Hi Siddarth

When talking about 2005 and/or operational reporting, yes, I agree stored procedures work well.

Post #823777

bella_porter

Posted Tuesday, November 24, 2009 9:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 24, 2009 9:12 AM
Points: 1, Visits: 0

This is an interesting kit! I wonder how hard it is to understand!

Bella

Post #823965

Siddharth Mehta

Posted Tuesday, November 24, 2009 9:32 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, March 13, 2011 4:45 AM
Points: 18, Visits: 94

I didn't get the meaning. If you would like to see something in this kit, or something that you didn't think belongs to this kit, please add your feedback. In case if you feel that this idea is garbage, in that case thanks for reading this article. Smile

Post #823982