olap

OLAP Cubes: Compatibility between Analysis Services 2005 and 2008

I'm working with Analysis Services and I have run into a compatibility issue. Here is my situation. I have 3 machines: Server2005: This machine has SQL Server, Analysis Services and Visual Studio, all in 2005 versions. Client2008: This machine has Visual Studio 2008. Client2005: This machine has Visual Studio 2005 What I'd like to d...

How to view MS SSAS 2005 sessions and queries

When browsing the cube in Microsoft SQL Server Analysis Services 2005, I would like to peek at the MDX (supposedly) queries generated by client access tools such as Excel. Is there a tool or method that enables me to do just that? I'm really looking for something like Oracle's v$sessions -- I know about sp_who and sp_who2 for the relati...

Analysis Services 2005 OLAP Cubes : Can I create a distinct count measure on a nvarchar column?

I'm trying to create a cube with a single measure. This measure is a distinct count of a "name" column. The cube works perfectly if the measure is set to "count" type. However when I set distinct count I get this error: "Errors in the OLAP storage engine: The sort order specified for distinct count records is incorrect" I have read in ...

What is the best way to use SQL Server Analysis Services data in a line of business application?

We'd like to see if we can get some improved performance for analysis and reporting by moving some of our key data into Analysis Services cubes. However, I haven't been able to find much in the way of good client front ends. Our users have Office 2003. The move to 2007 is probably at least a year out and the Analysis Services add-in fo...

Free controls for showing OLAP cubes

Hello all, is there a free set of controls to be used for representing the OLAP cubes in aspx pages? something like the ones from Dundas, but free and (if possible) cross-browser. Thanks, Lucian ...

How to assess performance of MDX in OLAP processing

I am familiar with standard practices to assess performance query or stored procedure using SQL server 2000/2005/2008. How is the best way to assess MDX performance? I assume its possible to write structurely correct but poor performance MDX queries as easily as you can with standard T-SQL? Any suggestions? FYI: I may be tasked with o...

browsing olap cubes

dows anybody know any fine open source cube browser??? ideally it would be something built with plain javascript... does it even exists??? I'm planing to use it with classic asp agains a sql database... thanks a lot ...

How to use 3rd dimension in MDX query (ON PAGES syntax)

Hello, I have a problems with 3rd dimension in MDX Query (on MS SQL Server 2005). I can use 3rd dimension in Visual Basic (I have a cube there, using browser I can make 3 dim. queries -- owing to ON PAGES). I snooped it via MS SQL Profiler (it records databases queries). But when I tried to put the query into MS SQL SERVER, only thing wh...

Java Chart library for OLAP

Dear All, Is there any java chart library that supports OLAP data, like ChartFX Olap or Dundas Chart ? Thanks ...

Loop through PageField in OLAP Cube [PivotTable]

Hi, I'm trying to write a VBA script that will draw buttons beside the PageFields in a Pivot Table, these buttons will loop through the values in the PageField. I had this working for a regular Pivot Table, but I've been asked to adapt it for an OLAP Cube (External Data Source) and I can't work out how to find the values for a Member usi...

Process dimension fails with message "A FileStore error from WriteFile occurred"?

Hi, I am trying to process a dimension using SQL Server 2005 Analysis Services. This has worked in the past without problems but recently fails. The dimension is hierarchical using 4 columns from a single table (the entire cube uses a single table). The error message received (regardless if I process the entire cube or the dimension, w...

Detecting KPI cell from Cellset when querying SQL 2005 Analysis Services

Given an MDX query that may return KPI values, is there a way to query the cells in the cellset object to determine whether they are actually KPI's? This way I can display trend/status images in the results instead of 0. -1 etc. ...

ADOMD.NET 9.0 Redistributable?

Got a problem with ADOMD.NET 8.0, SQL2008 and our app. It isn't giving us the right metadata. I can't find anywhere to download the ADOMD.NET 9.0 redistributable. Only way I can get it is by installing 2008 and grabbing the DLL. Any clues? ...

How to use a slowly changing dimension in Sql Server Analysis Services

In a data warehouse, I want to have a fact table which tracks certain metrics of a university application (average score on a standardized test, for example) and also the status of applications during different times of the year. For simpliciy, let's say a given application progresses through 3 states: New Being Assesssed Assessed an...

SQL2008: MSOLAP & SSRS Class not registered error with certain dimension.

Our product leverages Analysis Services combined with Reporting Services, we recently made some changed to add compatability for SQL2008. Everything works great except with certain dimensions, drillthroughs or measures added to a report we suddenly get this following error: Server: The operation has been cancelled. Errors in the hi...

Any Python OLAP/MDX ORM engines?

I'm new to the MDX/OLAP and I'm wondering if there is any ORM similar like Django ORM for Python that would support OLAP. I'm a Python/Django developer and if there would be something that would have some level of integration with Django I would be much interested in learning more about it. ...

How to handle large amounts of data for a web statistics module

Hi, I'm developing a statistics module for my website that will help me measure conversion rates, and other interesting data. The mechanism I use is - to store a database entry in a statistics table - each time a user enters a specific zone in my DB (I avoid duplicate records with the help of cookies). For example, I have the followin...

OLAP Pivot table refresh is resetting filter values

OK- 3 workbooks (one combined, and two seperate for two different combined areas) are accessing a CUBE reporting database that does a daily extract from Siebel. Each workbook contains approximately 15 sheets, and about 25 pivot tables. When a refresh all is done, and the OLAP query runs, it resets ONE of the filters on almost every s...

MDX - Sum at lowest time, then Max it out...

I have; a Time dimension (Year, Month, Day, Hour), a Product dimension (Product, Feature) and a User dimension (User) The measure I have available is: Used (Number of features that are in use) What I want to do, is to display the Max of concurrent usage. (This would be the Max of the Sum of Used for each Feature used by the same Use...

Joining fact tables in an MDX query

Hello All, I am building and Anaysis Services project using VS 2005. The goal is to analyse advertising campaigns. I have a single cube with 2 fact tables factCampaign: which contains details of what people interviewed thought of an advertising campaign factDemographics: which contains demographic information of the people interviewe...