A collective term for the field of developing reporting and analytic systems, often associated with data warehousing.

learn more… | top users | synonyms

0
votes
2answers
147 views

Daily snapshot fact table

I have a list of products per costumer. Costumers can delete or add products to their list. I want to know in each day what is the list of products (and count) by costumer. My first approach is to ...
0
votes
1answer
54 views

Business Logic in Data Warehouse

my question is: Should business logic be stored in the data warehouse data store? Or should it only exist in the reporting applications? To give a more concrete example: In the CRM operational ...
-1
votes
1answer
29 views

Use Oracle 10g BI enterprise edition with Oracle 11g database

Can i use Oracle 10g BI enterprise edition with Oracle 11g database. please tell. Thanks.
2
votes
0answers
95 views

How to insert values into Bridge Table in star schema?

I am modelling my database with respect to star schema with bridge tables. My master Table looks like below. I need to convert this format to star schema. MasterTable StudentNumber | Subject1 | ...
1
vote
0answers
129 views

BI - Cube Concept and MDX Query Help

In a Mondrian Schema, I have a fact table for Sales, a dimension table Time and a dimension table Client. I need to create a Saiku report where i can show How many clients Joined in per year. I have ...
0
votes
0answers
21 views

what is the difference between data migration and ETL?

What is the basic difference between ETL and data migration? Are not both terms are used for the same purpose ? Data migration includes extractions, transformations of data and Loading to target ...
0
votes
0answers
41 views

How to manage MySQL database with Oracle Fusion Middleware?

Is it possible to connect and manage a MySQL database with Oracle Fusion Middleware?
0
votes
0answers
37 views

Merge data using Integration Service

Please Consider this scenario: I have a table in my database. I want move this data in my OLAP database using SSIS.I can move all record from my table to OLAP database.The problem is I don't know how ...
0
votes
0answers
41 views

Identifying interesting data for further analysis

I frequently come across this kind of situation where i have a timeseries based data with lots of categories. What i'd like is some tool that can scan my data and tell me which categories are ...