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...
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...
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 ...
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...
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 ...
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...
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 ...
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...
Dear All, Is there any java chart library that supports OLAP data, like ChartFX Olap or Dundas Chart ? Thanks ...
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...
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...
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. ...
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? ...
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...
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...
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. ...
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...
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...
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...
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...