Cubes of some clients in Analysis Services

Question

Cubes of some clients in Analysis Services

Navigation

#1 by (3 votes)

3

I want to allow my clients to access your data to generate customized reports and use the power of Excel PowerPivot. Today all the clients (business) are in the same database and for the little that I know about cubes I draw the following strategy.

Cubes can stay on other servers (Azure, Amazon, dedicated physical server, ...). The important thing is that they will be generated from a main database (with all the data).

My questions:

Can I work this way?

How do I create a cube by restricting the id_bus? I am using SQL Server Business Intelligence Development Studio 2008.

Can I create a user who has read access to only a specific cube?

sql-server business-intelligence

asked by anonymous 09.10.2014 / 23:19

1 answer

How do I create a Team Project by branching the code from another Team Project in TFS 2013? Select label through .find

score 3 · Answer 1

I was able to resolve my demand using SSIS (Integration Services) with Visual Studio.

I create the bases (Basic) Azure SQL with the tables that I want to publish to my client
In SSIS I have created a package for each client with the source and destination connection of the data. I've also created a variable that is the client identifier the filters are going to consider.
I published the project in the Integration Services Catalog of the database and scheduled a JOB to run the packages all night.
For my client, I provide Azure (read-only user) access credentials that he will use in Excel's PowerPivot.

Follow the link for a good SSIS tutorial. It pays to give one an exploit to those who have similar demands or have some periodic work in data extraction / migration / transformation. You can even generate Excel spreadsheets with the data.

SSIS Tutorial with Azure SQL