Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can we use the cube data without deploying the solution? Expand / Collapse
Author
Message
Posted Tuesday, October 1, 2013 2:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 1, 2013 7:39 AM
Points: 13, Visits: 35
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
Post #1500291
Posted Tuesday, October 1, 2013 2:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 13,017, Visits: 10,800
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1500292
Posted Tuesday, October 1, 2013 2:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 1, 2013 7:39 AM
Points: 13, Visits: 35
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

Post #1500298
Posted Tuesday, October 1, 2013 2:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 13,017, Visits: 10,800
Either make sure the service account has read permissions on the database, or use another account for impersonation.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1500299
Posted Tuesday, October 1, 2013 3:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 1, 2013 7:39 AM
Points: 13, Visits: 35
This is kind of an odd question and I'm rather new to SSAS. How do I check the service account permissions on database?
Post #1500307
Posted Tuesday, October 1, 2013 3:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 13,017, Visits: 10,800
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1500311
Posted Thursday, October 3, 2013 3:18 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:31 PM
Points: 161, Visits: 461
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 ?
Post #1501359
Posted Thursday, October 3, 2013 3:24 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 13,017, Visits: 10,800
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1501363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse