olap

Can an OLAP cube be constructed where the details of the model are not known in advance?

Pardon me for the woolly question - I'm not really that familiar with OLAP & cubes. Let me explain my situation... I'd like to build a database to store questionnaire results, where there might be a few dozen questions per questionnaire. Having gathered a few thousand completed questionnaires, I'd like to analyze the results, and that s...

How do I show graphs and KPIs from an OLAP cube in Sharepoint?

I need to display content from an OLAP cube in Sharepoint. This could be done using PerformancePoint Server but unfortunately Microsoft has decided to drop support for that product some time ago. Their plan is to integrate some of the functionality directly into the next version of Sharepoint instead. The problem is that I can't wait tha...

What is the best approach to get from relational OLTP database to OLAP cube?

I have a fairly standard OLTP normalised database and I have realised that I need to do some complex queries, averages, standard deviations across different dimensions in the data. So I have turned to SSAS and the creation of OLAP cubes. However to create the cubes I believe my data source structure needs to be in a 'star' or 'snowflak...

OLAP and SQL Server Analysis Services

Could you recommend some tutorials regarding OLAP cubes (especially in the context of Microsoft Project Server) and SQL Server Analysis Services? Books would also be great. ...

DB2 web OLAP Viewer

Does anybody know of a web based something that would allow end users to interact (change selection) for an OLAP cube on DB2 ...

how to figure out which columns in the fact table are used for calculating measures in an OLAP cube?

I have to verify that olap cube data and the data from relational tables from where a cube is built is correct. And I will do so by writing the TSQL queries and compare the values with that of cube. But, I got stuck in the course of determining which columns are used for measure. How do I figure out which columns are used for measures?...

cube partitions: is the fact table in the DSV designer just one of the cube partitions?

There are 16 partitions for a fact table. All 16 of them have the same structure and have the same aggregation scheme. 15 of them contains data and while the 16th contains no data. So, is the fact table in the DSV designer just one of those partitions? (the name in the header matches one of the partitions though) if it is so, then w...

Writing updates to OLAP cube

Hi, What is the easiest way to write user entered measure values (sales forcast) to the SQL Server Analysis Services OLAP cube from a .Net client application? I'm aware that underlying fact table can be updated with DML statements and that cube can be reprocessed but I'm looking for alternatives. Regards, Aleksandar ...

Cube Configuration

On "Cube Configuration" page of Project Server, you have the option to add enterprise fields to the cube as dimensions. When you select the option "Assignment" from the cube drop down, you are given a list of available fields to choose from. However, some of the fields are labeled with a "R__Assignment" or "T__Assignment" suffix and i ca...

how to find out which columns to join

Is there an easy way to find out the column dependencies between tables in the DSV of a cube? The reason I am asking this question is: When there are lots of tables (fact and dim tables) in the dsv, it is hard to follow the lines. Help appreciated! ...

Calculated members: SSAS

In the "Calculations" tab of an SSAS cube project, does "Measures" dimension represent all measures within the measure groups as well? For instance: Patron Revenue has measures actual win, cash in, cash out.... Patron Redemption has measures operator pay, redeeming dollars, redeeming comp... In calculation tab, [Actual Gross Profit] i...

Trace back columns in calculated measures

How do I trace back the actual columns used/joined in calculated measure? THe reason I am asking this question is, I am trying to write the equivalent TSQL query to verify the result with that of calculated measure. So far, my approach has been a look up into the measure properties and find the table/view and the column name used. The j...

Help needed on calculated measures

Patron Revenue Cube: In one of the calculated measures “Acutal Gross Profit”, there are four measures used as “[Measures].[Acutal Win]-[Measures].[Operator Pay]-[Measures].[Redeeming Dollars]-[Measures].[Redeeming Comp]” The first two measures belong to vw_fact_patronrevenue view and the other two belong to vw_fact_patronredemptio...

EXEC sp_spaceused similar for DMX, MDX or XMLA?

I have the next query for MSSQL that will return the amount of free space on a database. Is there any analog for OLAP cube-types DBs? use [AxDWH_Central_Reporting] GO EXEC sp_spaceused @updateusage = N'TRUE' GO ...

What is the best way to model a ragged hierarchy in SSAS for both ROLAP and MOLAP?

I'm currently trying to model a ragged hierarchy in SSAS and I'm stuck. First, I was trying to model it like so: ItemKey,Level0Key,Level1Key,Level2Key Item1,Lvl0-1,Lvl1-1,Lvl2-1 Item2,Lvl0-1,Lvl1-1,Lvl2-1 Item3,Lvl0-1,Lvl1-1,Lvl2-2 **Item4,Lvl0-1, , ** Where the last line in this example had blanks for the "missing" levels. Here, RO...

Processing dimension in SSAS 2000

Hi, I have a shared dimension in SQL Server Analysis Services 2000. The dimension is used in two cubes. The dimension is marked as non-changing dimension. Names of some memebers in the database have changed. However no structal changes have been made. I process the dimension incrementaly, but the names of the memebrs stored in dimens...

How does OLAP address dimensions that are numeric ranges?

To preface this, I'm not familiar with OLAP at all, so if the terminology is off, feel free to offer corrections. I'm reading about OLAP and it seems to be all about trading space for speed, wherein you precalculate (or calculate on demand) and store aggregations about your data, keyed off by certain dimensions. I understand how this wo...

Package for presenting OLAP data

Hi, I'm managing a very large data warehouse (>1 TB) based on MS SQL 2005. I would like to create a solution for the users to present data from the cubes on-line (web interface). Right now they are using Office Web Components, but it's not so good. I don't have any controls over the reports that they create. I googled, and there are so...

Best approach for complex pivot report in Postgres?

I was just asked to create a report that slices and dices data. We are using postgres. Our schema is setup for OLTP. The system contains orders, they have one status (out of 15+). Orders are also decorated with various properties (8+). The properties are stored in a key/value child table (because they change all the time). End us...

Best method for using OLAP data in Web Application

We are developeing a BI portal and in that most of the data are from SQL Analysis Service OLAP DB. Please let me know which is the method for using the same in web application like ADOMD.NET, OPENROWSET inside existing SP,... Thanks in advance Bipin ...