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)? ...
Hi As I am new to SSAS,have been reading an article on Multi-Dimention OLAP Cube and struggling to understand Cube concepts, It has been said that Although the term "cube" suggests three dimensions, a cube can have up to 64 dimensions. Could you please explain how is this possible on cube (other than 3-Dim example x,y,z planes)? Please...
It appears to be a common practice to let the time dimension of OLAP cubes be in a table of its own, like the other dimensions. My question is: why? I simply don't see what the advantage would be to have a time_dimension table of (int, timestamp) that is joined with the cube on some time_id foreign key, instead of having a timestamp co...
I'm trying to push data into an OLAPCube in flex. The data coming in is flat and nothing else is known before hand. How do I have flex automatically create dimensions and such so that I can bind something to the cube? Using a flex chart, it's as simple as setting the data provider to an array collection and it works. The ONLY exampl...
I'm trying to create an OLAP Cube in Project Server based on a snowflake schema. I'm doing this programatically on the OnCubeBuilt event. I'm not using anything strictly related to Project Server, only the classes in the Microsoft.AnalysisServices namespace, but I wanted to be clear about what I'm trying to implement. Has anyone worked w...
I have an analysis services cube in SQL server 2005 which I'm connecting to via an excel front end. When I connect via one user its fine, but when I log on to the same machine as another user I get an error in my excel spreadhseet - "user...does not have access to the [Cube name] database" Obviously the first user has the correct permi...
I have this MDX query (based on the Foodmart sample database): SELECT {[Measures].[Profit]} ON COLUMNS, {CROSSJOIN([Product].[All Products].Children, [Time].[1997].Children)} ON ROWS FROM [Sales] This generates a result like this: [Product].[Product Family] [Time].[Year] [Time].[Quarter] [Measures].[Profit] --------------------------...
We have an SSAS server with a cube deployed on a server over the WAN.. We are trying to connect to the cube from Excel on various client workstations. The server is not on a domain with the clients. It "works" for some of us but not for others. We are trying and failing yet to determine what the difference is on the machines that wor...
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...
I have an application that requires analytics for different level of aggregation, and that's the OLAP workload. I want to update my database pretty frequently as well. e.g., here is what my update looks like (schema looks like: time, dest, source ip, browser -> visits) (15:00-1-2-2010, www.stackoverflow.com, 128.19.1.1, safari) --> 10...
I am using IIS 6.0 on Windows 2003 in a workgroup, and have created a web which runs in its own pool to connect to a Sqlserver 2005 Analysis Services database using msmdpump.dll. I have set the pool up with its own identity, but when I look on the Analysis Services server using Sqlserver Profiler, I can see that the requests are being m...
I am new to OLAP. I understand the table structure and ETL process. I don't understand when data is supposed to be deleted from the fact table. Say I'm creating a reporting application for events. each event has the duration it took to complete, the exit code and total bytes read. There are several dimensions, e.g. time and location. ...
We are developed a custom MOLAP engine for live processing a large amount of data in process. And now we got a requirement to integrate SSAS with our system. Dimension's meta info and attributes data are very easy to get. But how can I get facts data without making SSAS to calculate aggregates i.e. data that stored only on leafs? Aggre...
I have a cube developed using SQL Server Analysis Services (2005). Its hooked up to an excel front end. At the moment users have their own logon to the reporting server and access the reports that way. However, it would be nice of they could access the reports over the web. Are there options for this? I could upgrade to 2008 if there w...
Hi, I am working on a project in ASP.NET MVC using C# 3.0. I am using the Dundas Chart Control for OLAP. As the Dundas control does not directly support MVC it is used on a standard ASP.NET page with a codebehind file. This page is displayed in an iFrame of a normal View returned from a Controller Action. I have a button in the iFrame...
I'm using Analysis Services and when designing dimensions I'm never sure how far to go to build natural hierarchies. What I mean is I've added in all the genuine attribute relationships. So most hierarchies are natural anyway but the most commonly requested hierarchy is 3 or more levels with a middle level as a slowly changing attribut...
I'm attempting to create a ragged hierarchy in SSAS 2005. The "Category Name" and "Sub-Category Name" levels should be hidden in the hierarchy if either of them is blank. Leaf nodes which always have a value must display even if these two levels are blank. An image of how the measure has been configured is as follows: I thought using...
Not sure if what I'm trying to do is possible or if I need to change my data model. I have a dimension containing the different amouts a customer can loan so what I wan't to do is see the share of a certain amount compared to total sales. Pseudo code: member [Measures].[Share 5000] as 'count([Amount].[5000])/([Measures].[Total S...
Hi folks, i want to know if is it possible to avoid mondrian´s fatal error when it doesn't have any member in defined cube. for instance i have this MDX Query select {[Measures].[Unit_Sales], [Measures].[Quantity], [Measures].[Total]} ON COLUMNS, Hierarchize({([Country.CountryHeirarchy].[All Countries].[USA], [Products.ProductHeirarchy...