I have a SSAS 2005 database with 10 cubes. When I create the cubes from an XMLA script, it works fast, and I can browse cubes from SSMS, just as I should. After processing the cubes during the night, eveyrthing starts to work VERY slow. Opening cube list in SSMS takes few minutes, and it is like this all the time. What can cause this? ...
I am trying to work out through the sample code that comes with Fast Track to MDX. ...
So I have a fairly hefty cube that won't be much good without aggregations. I'm still in dev phases, so I'm manually attempting usage based agg design. I'm aggregating some of the main queries that we've designed. However, every time I pull these up, it looks like it's reading through each partition it hits (biggest groups are partitione...
I’m pretty new to the many-to-many dimensions but I have a scenario to solve, which raised a couple of questions that I can’t solve myself… So your help would be highly appreciated! The scenario is: There is a parent-child Categories dimension which has a recursive Categories hierarchy with NonLeafDataVisible set There is a regular Pr...
Hi! Does anyone know how to use the Date Template with the BIDS 2008, SSAS Project, Dimension Wizard? I keep getting an error - rightly so, I suppose - "Dimension not generated because it is bound to a time binding" (after having selected Generate a non-time table in the data source, in order to get to the Date template). I am trying t...
I'm trying to access the KPI metadata via ADOMD.NET (using MDSCHEMA rowsets) with SQL Server/SSAS 2008. When I get a given KPI VALUE field, for example in Adventure Works, it returns what I believe is the hidden measure associated with the KPI (e.g., [Measures].[Net Income Value]). But the Value has areal MDX expression associated with ...
I am looking for SSAS cube and MDX (Multidimensional Expressions) sites like our StackOverflow site. Any other resources for SSAS cubes would be welcome as well. ...
We have an Analysis Services cube that needs to be as real-time as possible. It's a relatively small cube that currently takes a couple of seconds to process. Are there any guidelines for this? I'm curious what other folks are doing. Also, what would be the impact of processing the cube too frequently? Would the main concern be th...
I was wondering if anyone could make some recommendations for the most impressive charting components for reporting services and analysis server. Has anyone found any animated solutions? Not just static graphs. ...
My environment: SQL Server 2005 for database and SQL Server 2005 Analysis Services. I have a fact table of 78M rows. I want to only process the first 10K rows in my development phase. Other than removing the rows from my Fact table, is there another way of achieving this? ...
I have a cube and I want to create a MAT column. This column is then expected to show up in the same way as a regular metric would. How do I create a column that is a Moving Annual Total in SSAS? A walkthrough / demo would work as well. ...
Environment: SQL-Server-2005, SSAS 2005 I am using the following formula to create a Moving Annual Total SUM ({[Time].CurrentMember.Lag(3):[Time].CurrentMember}, [Measures].[TRx Quantity]) The same column [Measures].[Trx Quantity] is used in other calculations and it works fine. This one, however, comes up with #Value! to indicate so...
I'm using SQL Server 2005 Analysis Services and I'm trying to calculate distance inside of an MDX query - so that I can get counts of the items that are near my current location. I've created a dimension with Latitude & Longitude, and have also created a .NET assembly to do the math - but am having a hard time getting it all to work out...
I have a DateTime column in my Time dimension table. I want to display this as just MM/DD/YYYY and hide the time component (which is 00:00:00 anyways). How do I do this? ...
What are the best resources for Analysis Server and Reporting Services in your opinion? Community based or otherwise. ...
I'm attempting to create a filter using PerformancePoint's Dashboard Designer. After going through the wizard, however, the "Confirmation" page displays the following message: No filter data retrieved Warning 1: Filter was created but no data was retrieved. To resolve the problme, follow the step(s) below. 1. Verify that t...
We were extracting data out of Netezza into txt files, loading into SQL Server and processing our SSAS cube(s) from there. We want to change that and load the cube directly from Netezza. What are the things to keep in mind for this? ...
This is how I am creating my moving totals as columns in my cube: MATTY (Moving Annual Total This Year) SUM ( { [Time Period].[Month].CURRENTMEMBER.Lag(12) : [Time Period].[Month].CURRENTMEMBER }, [Measures].[MeasureColumnName]) MATLY (Moving Annual Total Last Year) SUM ( { [Time Period].[Month].CURRENTMEMBER.Lag(24) : [Time Period]...
Hi , I have created Dealer dimension in SSAS 2005 and it has 3 hierarchies. By default the hierarchy created first is the default hierarchy of the dimension. Is there any way to change the default hierarchy to another hierarchy. ...
First some background: I have the typical Date dimension (similar to the one in the Adventure Works cube) and an Account dimension. In my fact table I have daily transaction amounts for the accounts. I need to calculate cumulative transaction amounts for different accounts for different periods of time. The catch is that whatever is the...