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
124 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 ...
-1
votes
1answer
3k views

How to determine if an Oracle table is locked or not?

We've been using BI software and a repository database that are installed on Oracle Enterprise 11gR2. Some of these batch reports will try to access a database table which may still be locked. How ...
1
vote
0answers
98 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
16 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
35 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
40 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 ...