-
What is Data Warehouse
Data Warehouse Data from different data sources is stored in a relational database for end use analysisData from different data sources is stored in a relational database for end use analysis Data is organized in summarized, aggregated, subject oriented, non volatile patterns. Data is a data warehouse is consolidated, flexible collection of data Supports analysis of data but does not support online...
idanh79
- Dec 2nd, 2009
DWh is (6 important points about DWH) : 1. Dedicated Data Base 2. Integrated Data 3. Subject Oriented 4. Time Variant 5. Nonvolatile 6. Decision Support Idan Halfon
jglickma
- Nov 25th, 2008
Okay there are two camps on this Bill Inmon which is Date and Coddbased database design that has grown into the ODS reporting DSS database and of course Ralph Kimball whose mythology comprises of a st...
-
Re-engineering of Organization
What is Re-engineering of an organization?
idanh79
- Dec 1st, 2009
Reengineering is a fundamental rethinking and radical redesign of business processes to achieve dramatic improvements in cost, quality, speed, and service, this is the same process while Re-engineering an Organization.Idan Halfon
-
What is the difference between Business Requirement Document and Use case Document. What is the difference. I need a good BRD and UC template.
idanh79
- Dec 1st, 2009
The UC is more technical analysis, the business requirement document is a word document which includes business analysis
mrnutt
- Sep 12th, 2008
A requirements document defines the business needs for a project. A Use Case Document defines the behavior of a system given a set of user interactions.
-
Olap and oltp
What are the main important differences between olap and oltp
ihatehyperion
- Dec 22nd, 2007
olap:online analytical processing is that which describes procesing at warehouses.oltp:online transactional processing is that which describes at the operational sites..oltp &nb...
-
Which are the OLAP tools available that are supported by Oracle?
jglickma
- Nov 25th, 2008
Supported by Oracle not owned well Cognos, Microstrategies, Business Objects and they have Hyperion Essbase 9 & 11, plus Oracle reports, Discover plus... their new version is packaged as a BI suite I ...
tarun
- Sep 24th, 2007
Hyperion essbase and interactive reporting?are OLAP tool
-
Business Analysis Terms
RUPBUILDSDLCPLATFORMAGILEINCEPTION PHASEUSED CASETEST CASEREALEASESYSTEMACTORDEPLOYEMENTIMPLEMENTATIONREC PROWHITE BOXJAD SESSION
gregoryvaughn
- Aug 14th, 2008
If you switch to code view while building your package object you can modify the MDX and add the non empty reserve word/function.
-
Discus two reasons why feeding data into OLAP system directly from the source operational system is not recommended
praveen.p
- Mar 5th, 2008
I think the more specific and technical answer would be the noremalized and denormalized form of data that exists in OLTP and OLAP machines. In OLTP machine you want to keep the data normalized becaus...
VAMSIKRISHNACH
- Dec 9th, 2007
Moreover BI tools need historical data also which is not present in OLTP sysms
-
-
What is the Service name for Microsoft SQL Server Analysis Services 2000?
MSSQLServerOLAPService
Ans