When I process a cube in Visual Studio 2005 I get following message: Process succeeded. Trace information is still being transferred. If you do not want to wait for all of the information to arrive press Stop. and no trace info is displayed. Cube is processed OK by it is a little bit annoying. Any ideas? I access cubes via we...
I am currently learning OLAP & MDX after many years of relational database development. Any tips on getting started in MDX? What are the best books and resources to learn MDX? ...
I have about 150 000 rows of data written to a database everyday. These row represent outgoing articles for example. Now I need to show a graph using SSRS that show the average number of articles per day over time. I also need to have a information about the actual number of articles from yesterday. The idea is to have a aggregated view...
How can you cascade filter the attributes of more dimensions in a SSAS cube, viewed in Excel 2007. For example, if we have a cube Sales with the dimension Time and dimension Client, once the dimension Time is filtered to show only the sales from a particular date, if "Client.ClientName" is chosen as a filter in the filter area, how can ...
I wonder if anyone can recommend a good book on SQL Server Analysis Services. I'm expecting to get very much involved with that technology, so 'For dummies' series won't work for me. Is Microsoft SQL Server 2005 Analysis Services good? Is Professional SQL Server Analysis Services 2005 with MDX better? ...
Can anyone recommend a good resource -- book, website, article, etc -- to help me learn SQL Server Analysis services. I have no knowledge of this technology right now but I do constantly work with SQL server in the traditional sense. I want to learn about Cubes and Using Reporting Services with it. I want to start from the bottom but ...
We are building an hosted application that uses MS SQL Server Analysis Services 2005 for some of the reporting, specifically OLAP cube browsing. Since it is designed to be used by very large global organizations, security is important. It seems that Microsoft's preferred client tool for browsing OLAP cubes is Excel 2007 and the whole i...
I am trying to build an OLAP datasource from a bunch of binary files, and our current model just isn't working. We are using SSAS as our analysis / reporting model for our results, but aren't able to get the performance we want out of SQL. Our main constraints are: The database is very large. We have huge dimension tables with mil...
Is there a similar way in SQL to achieve the following, but with sql server agent jobs instead? here's how I do it for stored procedures.. if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[storedproc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[storedproc] GO CREATE PROCEDURE [d...
Hello people! My company is heavily invested in the MS BI Stack (SQL Server Reporting Services, -Analysis Services and -Integration Services), but I want to have a look at what the seemingly most talked about open-source alternative Pentaho is like. I've installed a version, and I got it up and running quite painlessly. So that's good....
How to use DataMining feature of SQL Server 2008 with ASP.Net ...
I'm wondering if there is an easy way to load data from analysis services (SSAS) into SPSS. SPSS offers a product to put SPSS functionality on the analysis server, but to me this is backwards. I don't want to learn about SPSS or have the SPSS users in the office learn something else. I just want to give the analysis services data to...
My fact table looks like this yesterday a yesterday a yesterday a yesterday b yesterday b yesterday c today a today a today b today b tommorow a tommorow a tommorow c tommorow d In the end I need an Excel report like this repetition count 1 2 3 yesterday 1 1 1 tod...
Hello, I need to execute MDX query from command line (MS AS 2005). I have heard, that there is a program named ascmd, which can do this. Unfortunately, when I went to codeplex page I found that page supposed to deliver an ascmd doesn't work. Please help if you know any other page, where I can download ascmd or any other program execut...
I get this error message when installing SQL 2005 Analysis services. The cabinet File 'sql.cab' required for this installation is corrupt and cannot be used. This could indicate a network error, an error reading from the CD-ROM, or a problem with this package. Im installing from an ISO file downloaded from MSDN. How could anything b...
I'm trying to configure storage mode ROLAP for a partition in an existing SSAS cube. The cube is a little messy in that the measure group is defined by a named query (as opposed to a table) and the dimensions are defined in several different data source views (DSV). This is the error message I get when querying the cube with mdx: Execu...
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 would like to automate the deployment of my SSIS and SSAS artifacts to remote development SQL Server 2005 & 2008 instances on a scheduled basis. What would be the best solution for this? I am using TFS 2008 as the source control system, so I'd like to integrate the solution with MSBuild and a scheduled Team Build. ...
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 ...