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...
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...
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...
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. ...
Does anybody know of a web based something that would allow end users to interact (change selection) for an OLAP cube on DB2 ...
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?...
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...
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 ...
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...
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! ...
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...
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...
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...
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 ...
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...
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...
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...
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...
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...
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 ...