October 1, 2013 at 2:06 am
I'm new to SSAS and I've created an dummy solution of Analysis Services project. I don't have permission to deploy the solution on server. So, my question is Can I use the cube data without deploying the solution?
Or any other alternative to check cube data.
Thanks,
Jagz W
October 1, 2013 at 2:07 am
I don't think you can.
Prior to processing a cube (which is necessary to view the data), it is deployed to the server.
You could install SSAS locally though.
If there is an alternative, I would be as interested as you are.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 1, 2013 at 2:18 am
I tried to deploy on local. But it gives me below error :
"The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server."
My database is on another server and I'm using service account for Impersonation information.
Could you please help in this?
Thanks
October 1, 2013 at 2:28 am
Either make sure the service account has read permissions on the database, or use another account for impersonation.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 1, 2013 at 3:30 am
This is kind of an odd question and I'm rather new to SSAS. How do I check the service account permissions on database?
October 1, 2013 at 3:39 am
First you check which account is used to run the SSAS service. (you can do this in the SQL Server Configuration Manager)
Then you log into the database server and check if this user has read permissions on the database you are trying to read data from.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2013 at 3:18 pm
Hi Koen, forgive me for not posting a new article, but I wanted a reply from you since I noticed you did your MCSA SQL Server 2012 - MCSE Business Intelligence.
Where can I get training material for the 'Implementing a Data Warehouse with Microsoft SQL Server 2012' part ?
October 3, 2013 at 3:24 pm
There's a training kit available for that exam.
I didn't read it though. I did the exam in beta, so I didn't have any official preparation materials.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply