.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Aggregation for a SSAS database

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server


In a production db server I have on the Analysis Server the SSAS 2005 database deployed from a SSAS 2005 prj. Is it possible to create the aggregations without BIDS?

Any suggests to me, please? Thanks

View Complete Post

More Related Resource Links

Synchronize SSAS database

Hi All, When I synchronize SSAS database, I get the following error message. Either the '' user does not have permission to synchronize objects on the source or target instance, or the objects do not exist on the source instance.   Anyone know?  

Can SSAS 2005 run with Sql Server 2008 database engine?

Are there any known issues of running SSAS 2005 with SQL Server 2008 database engine?

Deploy the SSAS database with diffrent name.

Hi there, I am trying to deploy SSAS database which will be in different name. While deploying from BIDS I changed the name. It is just replacing the existing SSAS database with the name I gave and not getting the earlier database. I just want to keep one copy in working condition and another copy which i will be frequently deploying with changes so that it will not disturb the working database. Please let me know what can be the problem even though I am changing the name before deploying. Thanks, Palash

passing parameter from one report to another (SSAS database)?


 I created two reports using SSAS Databse as the report datasource.I need to call one report from another report while clicking one of the textbox(text Box properties--> action --> Hyperlink GO to Report)

1) How should I pass the parameter from one report to another (bcos I should pass like this [Month].[Month Name]&[09] ) ?
2) How Should I pass the parameter if I am using hyperlink "go to URL" to call the report?


SSAS 2008R2 - Enable to process a database using Oracle OraOLEDB data provider



I've created a data source in BIDS using provider OraOLEDB.Oracle.1. The Oracle database is 10gR2. The client installed on my computer is 10gR2. The connexion is OK when I use Test Connexion in BIDS.

In the data source view I created a very simple query: select * from user_objects. All is fine, the fields are correctly defined.

I've created a dimension based on this query with object_id as the key.

I've deployed the solution to the server. All is working fine for the moment.

But when I process the dimension I get a dozen of error messages like (sorry error messages are in french) :

"Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.Oracle.1' on line 8; 42000."

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de dimension portant l'ID 'Test' et le nom 'Test'.

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de l'attribut 'SUBOBJECT NAME' de la dimension 'Test' de la base de données 'CTRL_DOMAINES'.

Serveur : L'opération a été annulée.

Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.O

How to create a specific aggregation in SSAS 2005



I have created a SSAS 2005 prj and the related cube. I have created a SSRS report to query the cube, but the execution take more time. I think to create some aggregations related to one-two MDX queries. I have tried to build aggregation in BIDS but this feature seems authomatic. Is it possible to create aggregations based only on one or two MDX queries, please?

Any suggests to me, please? Thanks

Attach Database in Analysis Services 2005 (SSAS 2005)


Hi Guys,

I have some problem here..

I'm using SQL Server Analysis Services 2005.. I want to attach/detach my analysis database, but i cannot find any option there..

does anybody have the script to attach the database?


Many thanks and regards...

Roland Andreas

SSAS - Aggregation wizard not finding anly suitable aggregations


Hi all

I am currently working on a financial reporting project. We created a cube that contains general ledger data. At the begining of the development phase, I run the aggregation wizard and SSAS was able to create aggregations. Yesterday I retried to run the wizard and to my surprise SSAS was not able to find any suitable aggregation. I searched on the internet to find out if someone experienced the same behavior and found the following link:

We have several defined hiearchies on the [Organization] dimension that can benefit from aggregations.

I looked at the design of the cube and could not find any reason that could explain the behavior of SSAS (not finding any aggreg.)

In the end I took the solution from the point where it was still able to create aggregations and started to redo all the modifications (one after the other) always running the aggregation wizard in-between. I was hoping that at some point aggregations would not work anymore and that I could identify which modification is guilty. 

Strangely I was able to perform all the modifications and the wizard was still able to build aggregations.

I the scripted the corrupt database and the non-corrupt database and compared them (using a text comparison tool). I was not able to find any significant difference.

Did someone exprience similar problems? :-) I kn

Explanation on Aggregation Design Tab in BIDS for SSAS 2008?

Is there info on how the new aggregation design TAB in BIDS for SSAS 2008 works? It looks great but I have no idea what it does and how to use it. Is that just me?

SSAS Configurations for SQL Server Database and Cube on one Server


Currently, my system has SQL Server 2008 and SSAS on one server,

and when querying is active, SSAS shows memory problems.

From the web, I found this document,

SQL Server Databases and cubes on one Server


and as the document suggests, I'd like to change memory related setting for SSAS.

But the document is based on 2005 version.

Any suggested parameter values for 2008 ?

Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Adding Rows in GridView without using a Database

This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

ASP.NET Database Tutorial

This tutorial will show you how to display data using the .NET GridView Control, ASP.NET 2.0 and VB.NET

The GridView control is a powerful tool and is simple to implement.

First, you will need to import the System.Data.SqlClient namespace.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend