416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
This is the support page for the legacy Dundas Dashboard application. For assistance with the current Dundas BI application please click here.
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

SQL Server Analysis Services - Advanced Properties

Hide navigation
RSS
Modified on Thu, 21 Feb 2013 06:12 PM Categorized as Data Connectors
Click to return to: Documentation | Connecting to Data | Advanced Properties for Data Providers | Data Provider - SSAS


Overview

This article describes the advanced properties of the Microsoft SQL Server Analysis Services (SSAS) data provider.

Properties

Advanced

Property Name [Script Name]TypeDescription
Character Encoding [CharacterEncoding]stringSets how characters are encoded.
Compression Level [CompressionLevel]int?Sets the packet size, in bytes, of network communications between client and server.
CustomData [CustomData]stringSpecifies script expression for the CustomData property of the connection string.
Locale Identifier [LocaleIdentifier]int?The locale ID (LCID) specifies the database's collating order, which is the character set that will be used to determine how values in the database are sorted.
Packet Size [PacketSize]intSets the packet size, in bytes, of network communications between client and server.
ProtocolFormat [ProtocolFormat]ProtocolFormatOptionsSets the format of the XML sent to the server.
TransportCompression [TransportCompression]TransportCompressionOptionsSpecifies whether the messages on this connection are to be compressed.

Context

Property Name [Script Name]TypeDescription
ClientProcessID [ClientProcessID]stringSets the process ID of the application that is to be associated with this connection. This value can be useful when monitoring trace events.
SspropInitAppName [SspropInitAppName]stringSets the name of the application that is to be associated with this connection. This value can be useful when monitoring trace events.

Initialization

Property Name [Script Name]TypeDescription
Connect Timeout [ConnectTimeout]intSets the time to wait for a connection to be established before the AdomdConnection stops trying to connect and generates an error.

Provider Options

Property Name [Script Name]TypeDescription
Cube Check Interval [CubeCangeCheckInterval]intInterval for cube update check.
Load Perspective Actions [LoadPerspectiveActions]boolGets or sets a value indicating whether actions from perspective should be loaded.

Security

Property Name [Script Name]TypeDescription
ProtectionLevel [ProtectionLevel]ProtectionLevelOptionsSets the level of protection that the provider uses to sign or encrypt the connection.
Use Encryption for Data [Encrypt]boolSets whether encryption is used between the client and server. If set to true, all data sent between the client and server is encrypted with Secure Sockets Layer (SSL) encryption, provided that the server has a certificate installed.

Examples

Using the CustomData property

This example shows how to use the CustomData property to pass a custom attribute value into the SSAS connection string. The attribute value will be specific to the Dundas Dashboard user (account) who is logged in. On the SSAS side, you can then configure it to return data as appropriate based on the custom attribute value (which is user-specific).

Step 1: Set the CustomData property value

  1. In the General tab of the Data Connector Designer, click the Advanced button to see the list of SSAS advanced properties.
    SSAS data connector advanced properties.
  2. Locate the CustomData property which lets you enter a DundasScript expression. Click the ellipsis button of the property to open a Script Editor dialog.
  3. In the Script Editor, type the following script expression, which retrieves a custom attribute value based on the current user who is logged in to Dundas Dashboard:

if(AccountInfo.CustomAttributes.ContainsKey("myattr")) { return AccountInfo.CustomAttributes["myattr"][0]; } return string.Empty;

Script for the CustomData property.

Script for the CustomData property.


Step 2: Set the custom attribute value per-user

Next, give each user account the same custom attribute name but different value to distinguish between them. Set the custom attribute on a per-user basis as follows:

  1. Go to the Administration sidebar.
  2. Edit a user account. The Editing Account screen is displayed.
  3. Click the Custom Attributes tab.
  4. Add a new custom attribute where:
    • Name: myattr
    • Value: 0001

Adding a custom attribute to a user account.

Adding a custom attribute to a user account.


Now, when the Dundas Dashboard admin user is logged in and connects via the SSAS data connector, the custom attribute value 0001 will be passed in to SSAS via the connection string's CustomData attribute. You can then configure SSAS to return or give access to the appropriate data based on the CustomData value.

Related topics


Click to return to: Documentation | Connecting to Data | Advanced Properties for Data Providers | Data Provider - SSAS

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.