Search results for query: *

I have a fact table that contains a few percentage values as well as numerous numerical values. Naturally I want to aggregate the numerical values, but not aggregate the percentage values using Analysis Services 2005. I have set the property AggregateFunction = Sum for the numerical values and...

I have an SSAS database that contains multiple cubes. All these cubes display as data sources in Report Builder. Is there a way to only allow one of the cubes to display in Report Builder short of creating another SSAS database with only that cube? Thanks. ...Phillip

I created a cube perspective, and unchecked 3 dimensions, so that the parent dimension and child attributes are all unchecked. I saved the solution, reprocessed the SSAS database, and regenerated the SSAS report model. When I open a Report Builder report based off this report model, and select...

Can the SSAS MeasureGroupMeasures function be used with calculated members? If not, is there another way to collectively call large numbers of calculated members in an MDX query without listing each one individually in the SELECT? Thanks. ...Phillip

I'm wondering if there is a way to dynamically add and delete users within SSAS roles. I'm currently adding and deleting users manually and handling their role restrictions by way of MDX expressions, but I wonder if there is a way to add and delete them dynamically, possibly using MDX...

Errors in the high-level relational engine. The following exception occurred while an operation was being performed on a data source view: Could not load type 'System.Data.Keywords' from assembly 'System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' due to value type...

Hi, me again. Can someone tell me how to handle SSAS date range queries? SSAS cube? Specifically I'm trying to query an SSAS 2005 cube to get a date range and the associated measure data for that date range using SSRS. I'm assuming I need to use MDX, but I'm not real proficient with MDX at...

Can someone point me to resources describing how to report on historical and current data within an SSAS cube that uses a slowly-changing dimension? I know how to implement the SSAS dimension using the SCD attribute types (scdStartDate, scdEndDate, scdOriginalID, and scdStatus), but am not sure...

Is there any way to return the actual ranking indicator (e.g. '1' for the highest ranking, '2' for the next highest ranking, etc.) along with the ranked values themselves using the TopCount fucntion or any other SSAS function? We're trying to report the ranked values along with their actual...

Can anyone direct me to any SSAS vs. Essbase comparison documents? Or does anyone have any information to share regarding comparison of the two? Thanks. ...Phillip

Does anyone know of any hard-and-fast rules that can be used to approximate cube processing times (full and incremental) for a production system? Thank you.

I'm trying to synchronize my QA and DEV SSAS databases. The QA database is on a Workgroup server separate from another Workgroup server that contains my DEV database. When I try to select the "Source database:" dropdown list in the "Select Database to Synchronize" window of the wizard, the...

I've configured my SSAS server (Windows Server 2003) using the msmdpump.dll component, so that I can remotely access my SSAS database using SQL Server Management Studio. When I test the configuration by connecting to the pump via an IE browser, I get "%1 is not a valid Win32 application." Has...

Is there a way to disable 'Grand Total' for my SQL Server 2005 Analysis Services cube, so that it won't show up in the BI Dev Studio cube browser during design time or any reports built off the cube UDM after deployment? You'd think this would be easy, but I'm not finding any way to do this or...

I created a cube using SQL Server Analysis Services 2005, and I'm viewing the results in the Browser window. Is there any way to view or otherwise produce the MDX code that generates the Browser window results? Thanks.