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
Hi, 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]& ) ? 2) How Should I pass the parameter if I am using hyperlink "go to URL" to call the report?
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
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?
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...
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
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 ?