Sign in
 
Home20122008 R2200820052000LibraryForums
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
SQL Server >
> 
> 
Tabular SSAS perspectives in PowerView SQL Server 2012 SP1

Answered Tabular SSAS perspectives in PowerView SQL Server 2012 SP1

  • Friday, November 23, 2012 2:50 PM
     
     
    Sign In to Vote
    0

    Hi,

    I've heard that in SP1 we can now reference tabular perspectives in the RSDS connection string. I've looked around but can't find anything relating to this.

    Could somone give me an example string of how the perspective name is added to the connection string please?

    Thanks

    Mike

    Mike Dobing

     

All Replies

  • Friday, November 23, 2012 3:12 PM
     
     Answered Has Code
    Sign In to Vote
    0
    It is something like this:  
    Data Source=localhost\TABULAR;Initial Catalog=Adventure Works Internet Sales Model Denali CTP3;Cube=Test Perspective
    From: Power View should accept an rsds with Cube=Perspective in the connection string
     
  • Wednesday, November 28, 2012 9:35 AM
     
      Has Code
    Sign In to Vote
    0
    It is something like this:  
    Data Source=localhost\TABULAR;Initial Catalog=Adventure Works Internet Sales Model Denali CTP3;Cube=Test Perspective
    From: Power View should accept an rsds with Cube=Perspective in the connection string

    We have the initial release of SQL Server 2012 Enterprise Edition (11.0.2100.60) and have a SSAS Tabular Database with perspectives. We need to access one  of these perspectives from Powerview so we created a .rsds connection file. The Cube parameter is accepted in the connection string but it doesn't work, Powerview keeps showing all objects of the cube. Is it needed an update to SQL Server 2012 SP1?

    Thanks

    Juan Vilas


    • Edited by jjvilas Wednesday, November 28, 2012 9:36 AM
    •