Home Dashboard Directory Help
Search

Conditional Personalization Extensions by David Beavonn


Status: 

Active


2
0
Sign in
to vote
Type: Suggestion
ID: 780922
Opened: 3/7/2013 6:30:14 AM
Access Restriction: Public
0
Workaround(s)
view

Description

Analysis Services has a feature called personalization extensions which allows for a cube to have characteristics that are defined at the time the cube is used. For example, the user can access sets and members and kpi's that are specially defined for them alone.

One limitation is that there is no way to determine the context in which the user is accessing the cube. Because the personalizations can slow down the connections, we only want them to occur within Excel pivot tables. In other scenarios (eg. connecting from custom-written applications) we don't need the personalizations.

We were hoping to be able to access connection string details from the personalization extensions (SspropInitAppName or CustomData) but that has proven impossible.

See http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/81fa6cfe-898d-4f17-b7e6-87bd31083d91 for more info.
Details
Sign in to post a comment.
Posted by David Beavonn on 3/7/2013 at 6:31 AM
see http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/81fa6cfe-898d-4f17-b7e6-87bd31083d91
Sign in to post a workaround.