On-Line Analytical Processing, a class of systems designed for fast calculation, reporting and analysis of aggregate figures.

learn more… | top users | synonyms

4
votes
1answer
349 views

Should I snowflake or duplicate it across my facts?

I'm building up a data warehouse to be used by SSAS to create cubes on, and I'm debating between two possible schemas. In my warehouse, I've got two different fact tables that tracking daily changes ...
1
vote
1answer
265 views

Is processing required dimensions enough or to process the entire cube?

I have four large dimensions and one of the dimension is not going to be changed, also the particular dimension didn't need to be processed. So, processing the three dimensions individually updates ...
1
vote
1answer
57 views

How to keep archive table accessible for some users which is not frequently accessible?

I have partitioned my table based on some boundary ranges. My Database is built at MSSQL server 2008 R2. I have done partitioning for a table which has 40 million records in it. Now it's time to ...
0
votes
1answer
16 views

Adding templated Date-Time dimension to the cube

I have a database with FactSales table that contains Date column of type I4. I have created a cube and linked dimensions via foreign keys as usual, however, since I have no DateTime table in the ...
3
votes
0answers
775 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 | ...
2
votes
0answers
360 views

Semi-additive measures for other dimensions

I am looking for a way to do semi-additive aggregations on a non-time dimension. The model I am working with is similar to a snapshot inventory warehouse. Specifically I am analyzing processes ...
1
vote
0answers
309 views

Need to write MDX for time dimension in Mondrian

This is my Dimesion and Measure: <Dimension type="TimeDimension" foreignKey="ReqDateKey" name="Date"> <Hierarchy name="YQMD" hasAll="true" allMemberName="All Dates" primaryKey="date_id"...
1
vote
0answers
96 views

How to calculate run-off triangles?

(Note: This is copy of my question on StackOverflow here.) Reality description: We do have a list of projects. In every project there is a lot of accounts. You can do a lot of actions on every ...
1
vote
0answers
263 views

ETL import more dimensions from only 1 column

I was requested at work to learn ETL. I have already created a database without using ETL with some dimensions and consolidations, etc, containing above 1 billion numerical values. Now I have to ...
0
votes
0answers
13 views

Star Schema from Relational Database

I'm a newbie to data warehousing and I've been reading articles and watching videos on the principles but I'm a bit confused as to how I would take the design below and convert it into a star schema. ...
0
votes
0answers
15 views

OLTP to OLAP process causing deadlocks and impacting customers

I should preface this with the fact that I'm a .net developer who has fallen into DBA and performance work because it has become business critical, so I'm missing the DBA skills for this kind of work. ...
0
votes
0answers
27 views

Is it possible to use Hibernate for OLAP-server?

I have a PostgreSQL database with Java Hibernate. I need a XMLA datasource for a pivot grid client component. Is it possible to use Hibernate for a OLAP-server? Which OLAP-server does support ...
0
votes
0answers
12 views

MDX query with multiple dimensions on date, including “previous business week”

What is the simplest MDX that satisfies this query: The frequency of an event during each daily 10 minute interval, comparing today and the previous business week (Mon-Fri). The output should look ...
0
votes
0answers
7 views

Replicator service for OLAP star schema

We have a table which has dimensions as its own column. That table needs to be converted to a star schema for OLAP. We cannot use degenerate dimensions. MySql is our datasource of the existing table. ...
0
votes
0answers
159 views

Handle Duplicate entries in Fact table in Data Cube

We have been constructing data cube for our project in which we are facing a problem like 1 to many relationship in the dimension tables and making entries in fact table (duplication). ...
0
votes
0answers
52 views

Mysql - too many Deletion - Insertion

I'm creating cron jobs for my OLAP system. I have a cron job that deletes the records from the summary table first and then insert the records in it again: Say Deleting 1 month records, and ...
0
votes
0answers
172 views

CREATE OLAP server

I have a MySQL database server along with replication server, i.e. OLTP system altogether. As I have very heavy data fetching queries for the decision making reports. I need to create data-ware house ...