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...
Anyone know if there are plans for LINQ to MDX . Does any way currently exist to use LINQ with MDX / CUBES ...
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?...
I noticed that the fact tables used in a cube were actually views. Infact they were the templates of the fact tables (i noticed it in the script that "where 1=2" was used for the fact-views). So, if the template is used, there wont be any data in the view at any cost (and i dont know if I can insert in the view becasue I dont have inse...
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...
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...
Hi there, Is there any control around where I can have something like Flex OLAP Data Grid for Silverlight? I tried to create one on my own, but hitting the wall all the time, if there aren't something like this in the market, can we brainstorm a bit on how to approach creating a control like this? Thanks ...
Hi, We have a two-cube solution built in AS 2008 that works like this: an Industry cube that contains Widget data for all clients, and a Client cube that contains Widget data & shares several (but not all) dimensions with the Industry. The Industry cube contains everybody, including the calling client, so when the Client is pulling an ...
Hi everyone! I've been studying the paper condensed cube: the effective approach to reduce the cube size and i have a question, does the min-cube or bu-bst cube store the data by using array? or they store it using tree? Thanks everyone :) ...
We were extracting data out of Netezza into txt files, loading into SQL Server and processing our SSAS cube(s) from there. We want to change that and load the cube directly from Netezza. What are the things to keep in mind for this? ...
Hi , I have created Dealer dimension in SSAS 2005 and it has 3 hierarchies. By default the hierarchy created first is the default hierarchy of the dimension. Is there any way to change the default hierarchy to another hierarchy. ...
Hi , I have defined dimension security in my OLAP cube by creating roles and assigning users to each roles. Each user in a role can only see the location they belong to. When I browse the cube using a role , I see correct location for that role. But, when I browse the cube using "Other User" feature in "Change User" and test it for the...
Does anyone have resources that give a list of things to consider when designing a ROLAP cube, as opposed to MOLAP (I'm doing it in Pentaho, but I guess the principles are not dis-similar for other implementations). For example, I'm thinking of things like: should extra transformational work be done at the ETL stage to reduce computati...
Say I have a measure, foo, in a cube, and I have a reporting requirement that users want to see the following measures in a report: total foo total foo excluding instances where foo > 10 total foo excluding instances where foo > 30 What is the best way to handle this? In the past, I have added Named Calculations which return NULL if fo...
Does anyone have experience of using postgresql for an OLAP setup, using cubes against the database etc. Having come across a number of idiosyncracies when using MySql for OLAP, are there reasons in favour of using postgresql instead (assuming that I want to go the open source route)? ...
I have processed a SSAS cube. After it was done processing, I hit the close button - and then realized that I should have saved the output. I think SSAS stores the processing log as a text or XML file, but I do not know what folder to look into. Can someone direct me to retrieving processing logs? ...
I want to learn about olap and 'cubes', I have a very limited understanding and looking for recommendations on good beginner books on these sort of topics. I use sql server primarily so if the book is geared towards sql server it would be ideal. ...
I have an MDX query with the following calculated member: with member [Measures].[BBOX] as Count( Filter( CrossJoin([Dim Response].[Response ID].Children, [Dim Question].[Question Text].Children), [Measures].[Question Bottom Box] > 0) ) The idea is that I want a count of the combinations of two members o...
Is there a way to compare all information (aggregates, down to the detail level) between two OLAP cubes? For example, say I wanted to compare one cube created to work with sql server 2000 to that same cube, but migrated to run on sql server 2005/2008 - technically they should both return the same information for all dimension / measure c...
I'm working on a problem where i need to process multi dimensional data in memory using C#. My requirement resemble OLAP cubes but are not as complex. for example i don't need calculations or aggregation or stuff like that. I basically would like to reference data using multidimensional keys. for example: var key = new Key(); key["Dim1...