Hi, I'm trying to ask to a cube on SQL Server 2008 with a huge mdx query. This query contains more than 20 calculated members (defined on the query). Each member contains a restriction for a dimension on the cube. Not always need all dimensions, but sometimes it is needed. Well, it works fine until 16 members. With more than 16 membe...
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'm trying to create a mining model for forecasting against some DW data. I'm using SSIS for my ETL, and trying to use the Data Mining Model Training destination. Unfortunately I'm receiving an error whenever the column I'm trying to predict is numeric or decimal format. I don't get the error when I create the model by hand in SSMS, a...
I want to rename my SALES cube to SALES_2009 and put a new cube called SALES. When I rename it, the ID remains as SALES so my new cube now is called SALES, but it's internal ID is SALES_2010 (and my old cube is called SALES_2009, but the internal ID is SALES). Can the ID of a SSAS database be changed? I have tried the properties windo...
Hello, When I go to browse a cube I created in SSAS, I am getting this error: TITLE: Microsoft Visual Studio Unable to get the window handle for the 'ActionsAwarePivotTable' control. Windowless ActiveX controls are not supported. Anybody know why and how I can fix this? Thanks. ...
Hello, This is very odd; I setup a simple mining structure, and when I go to process it, I get this error. Doesn't point to the file the error is in, lists line and column as zero. What would this be related to? The ddl100_100:HoldoutMaxPercent element at line 184, column 38 (namespace http://schemas.microsoft.com/analysisservices/20...
I am building and deploying a SSAS cubes using AMO. I need the complete object model for AMO as an XSD (in schema form). I currently have built a schema by hand based on things that I need, but I'm afraid there would be elements that will come up during development time later on that will cause the upstream process that fills an XML f...
I am exposing data from a SSAS server to which users can connect from any tool they like, (in practise usually Excel 2007). We would like to provide URLs in some cells and would like Excel to recognise these as hyperlinks and make active and format accordingly. When we put a URL into a cell, it is just rendered as plain text. If you t...
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...
Is it possible to use Entity Framework (any version, including, and preferably 4.0) to query an SSAS cube (preferably SSAS 2008)? ...
In the SQL Server 2005 books online section "Defining Named Queries in a Data Source View (Analysis Services)", it states: A named query can also be used to join multiple database tables from one or more data sources into a single data source view table. Does anyone know where I can find examples or tutorials on how this can be don...
I am trying to deploy reports that connect to an SSAS cube as a shared data source. The problem I'm having centers around that fact that even if I change the Initial Catalog in the SSAS connection string, all the MDX queries in the rdl files still reference the old SSAS cube by name. This is a particular problem because these cube names...
I'm setting up a new cube in Analysis Services, and used the Business Intelligence wizard to work out the currency conversion issues. Now this all works perfectly, money is converted at the leaf level and summed up for display in the user's choice of reporting currency. My problem now is the calculation of liability. For liability, I ne...
I currently use Excel and SQL Server Business intelligence studio to browse my models, but I've been searching high and low for a decent, moderately user-friendly front end application that can be used for trudging through a SSAS Mining Model. I understand how to use the predictions for specific purposes (such as integrating with call q...
This may not be a direct programming question but I am in desperate need of this and if you people feel that the question is irrelevant , please do close it but after the answer. Like if we visit www.asp.net we will get the videos(free and down loadable) for asp.net, ajax etc.). Likewise, which is the site from where I can get the free...
I am getting the following error when deploying. This is in a cube which was working fine, all that has changed is a key column in one of the dimensions. Internal error: Failed to generate a hash string I have no idea what is causing this but even if I change the dimension back to how it was and try to deploy I get the same error. If...
I'm trying to create an MDX query on the TFS cube which gets the historical values of the Estimate field. For each task I want to get the last estimate for each person who set the Estimate field. For example if Bob the project manager sets the estimate to 24 hours and then Dave the developer sets it to 32 hours, I want to create a quer...
As part of a project to create a tool to query all sorts of permissions relevant to users in our area at work, I need to query some information about our database servers. The servers run SQL Server 2005 (including instances of Analysis Services 2005). I need to be able to find for a given server: The list of logins on that server The...
Hi there, I am running a SSAS cube that stores facts of HTTP requests. The is a column "Time Taken" that stores the milliseconds a particular HTTP request took. Like... RequestID Time Taken -------------------------- 1 0 2 10 3 20 4 20 5 2000 I want to provide a report ...
Reports against an SSAS 2005 cube with Currency formatted measures. In Cognos 8.2 a $ is properly displayed. In Cognos 8.4 an * is displayed instead of a $. Have you encountered this problem, and how have you worked around it? ...