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
111 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 ...
0
votes
2answers
169 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
32 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
205 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
149 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
17 views

What known strategies, if any, can I use to validate a Slowly Changing Dimension?

I have a customer dimension in our data warehouse (SSAS 2014 Multidimensional). It is set up as a Type II SCD, with just Start and End Date fields to track changes. (null end date = current). As our ...
0
votes
0answers
124 views

RapidMiner Not Connecting To SQL Server Database Connection

I recently installed RapidMiner and tried connecting the application to my MS SQL database connection via the Manage Database Connections feature. I have followed video tutorials on integrating SQL ...
0
votes
0answers
65 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
43 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 ...