Showing posts with label analysis. Show all posts
Showing posts with label analysis. Show all posts

Friday, March 30, 2012

restrict local cube

Does anyone know how can we prevent users from creating offline/local cube (in Excel) from our OLAP/Analysis Service server ?
Thank you.I'm almost certain that this isn't possible. There are ways that you can make it a bit more difficult, but those will only annoy your users.

If you find some way to do this, please let me know how you went about it.

-PatP|||Deny them access to the cubes ?|||Deny them access to the cubes ?
No, users still allowed to perform live access but must be prevented from creating local (offline) cube which they can bring home.

I'm aware of a new property introduced on SQL 2000 SP3a named RESTRICTED CLIENT but not sure if it has anything to do with our need nor how to set it up.sql

Wednesday, March 21, 2012

Restoring SQL 2005 Analysis service database backup on SQL 2000

Hello
I think the subject line says it all.
Is there any way to import my cubes, measures from SQL 2005 Analysis
service to SQL 2000 Analysis service database.
Madhur> I think the subject line says it all.
> Is there any way to import my cubes, measures from SQL 2005 Analysis
> service to SQL 2000 Analysis service database.
I do not think so. If you have a data warehouse, you can create a fresh OLAP
2000 cube. If not, you have problems. What you could do is you could
regenerate a SSAS 2005 project with BI Dev Studio, then generate the DW
schema in a relational database from the project, and finally generate the
OLAP 2000 cube from the DW. You have to export the data from the SSAS UDM to
the DW and then process the OLAP 2000 cube.
maybe I am wrong, but at the moment, I cannot imagine an easier process.
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

Restoring SQL 2005 Analysis service database backup on SQL 2000

Hello
I think the subject line says it all.
Is there any way to import my cubes, measures from SQL 2005 Analysis
service to SQL 2000 Analysis service database.
Madhur> I think the subject line says it all.
> Is there any way to import my cubes, measures from SQL 2005 Analysis
> service to SQL 2000 Analysis service database.
I do not think so. If you have a data warehouse, you can create a fresh OLAP
2000 cube. If not, you have problems. What you could do is you could
regenerate a SSAS 2005 project with BI Dev Studio, then generate the DW
schema in a relational database from the project, and finally generate the
OLAP 2000 cube from the DW. You have to export the data from the SSAS UDM to
the DW and then process the OLAP 2000 cube.
maybe I am wrong, but at the moment, I cannot imagine an easier process.
Dejan Sarka
http://www.solidqualitylearning.com/blogs/