BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

transactional data warehouse reporting


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
lavinaluo
Principal Member
Principal Member



Joined: 13 Feb 2005

Posts: 226
Location: Michigan



PostPosted: Wed Jun 16, 2010 3:09 pm 
Post subject: transactional data warehouse reporting

I never worked on a data warehouse based on transactional data. I do want to find out what will be the difference while generating report vs working with dimentional modeling data warehouse.

Any comments suggestions are greatly appreciated.
Back to top
jcaparula
Principal Member
Principal Member



Joined: 15 Aug 2002
ASUG Icon
Posts: 325
Location: Madison, WI



PostPosted: Wed Jun 16, 2010 4:23 pm 
Post subject: Re: transactional data warehouse reporting

Strictly speaking a data warehouse is not transactional, an OLTP database or ODS (operational data store) is. Most transactional data stores I've worked with are highly normalized (meaning thousands of tables), so most of the work is identifying the handful of key tables that are needed for reporting and how they interrelate.
Back to top
GowthamSen
Principal Member
Principal Member



Joined: 31 Aug 2006
ASUG Icon
Posts: 387
Location: INDIA


flag
PostPosted: Wed Jun 16, 2010 4:50 pm 
Post subject: Re: transactional data warehouse reporting

Hi,

Even though you have a relational database, you can still do reporting.

Dimensional modeling is costlier and ofcourse it shows better performance.

And when you say about Transactional data, if we create reports on this data, the reports might be slower and it would impact transaction systems performance, reports data varies rapidly if you transaction data is having updates very frequently.

There are lot of factors, by which we define reporting. That is the reason, a separate data warehouse environment would be created and then will be loaded from transaction systems.

_________________
Gowtham Sen

BO XI R2| BO XI R3.1 | Crystal Reports XI R2 | Xcelsius| SAP Integration with BO | Exploring SAP SPM

Looking for JOBS in US - www.fuzure.com | www.jobcreeper.com

Other than BO forum check out: www.xpert4ms.com
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0275 seconds using 18 queries. (SQL 0.0030 Parse 0.0008 Other 0.0236)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo