15

Dec

2014

Custom Security and Data Driven Subscription (DDS)

Single-Sign-On in DDS with MS SQL and SSAS


The BI Portal offers all the components for the SSRS DDS to work with a Single-Sign-On and custom security. The solution also extends the default DDS capabilities by allowing subscriptions to custom documents such as SSAS ad-hoc reports, business-rules-based report deliveries, and DDS for MS SQL Standard and Express Editions.

Comments (0) Number of views (7629) Article rating: No rating

7

Dec

2014

Memory Analysis and Caching in SSAS

1) SSAS is a file-based engine.  Requesting files goes thru the System File Cache. The actual memory used by the SSAS is a a combination between the one used by the process and the one used for caching files by the OS.     

2) The SSAS IO should be broken down into Logical, Physical, and Cached.

Comments (0) Number of views (17443) Article rating: 4.0

6

Dec

2014

Memory and Disk IO in Windows

1) Memory used by a process is backed up by either physical memory or a file. The Windows OS is responsible for figuring out the best way to allocate memory among the processes on the system.

2) Disk IO is issued only if the required pages are not found in the System File Cache or in the Process Physical memory.

Comments (0) Number of views (6559) Article rating: No rating

6

Dec

2014

Application Deployment Guide

Companion for MS SQL Server

The installation of the Companion for MS SQL Server goes thru three easy steps:

1. Installing the service software
2. Configuring the service with the SQL Server Data Collection Services Manager.
3. Starting or installing the Client.
Comments (0) Number of views (6148) Article rating: No rating

5

Dec

2014

Single-Sign-On (SSO) with SSRS, SSAS, and SQL

The BI Portal offers a complete security solution. It supports all security models offered by SSRS, SSAS, and SQL.  It also allows the user to login once and his/her identity to flow to the Web App, SSRS, SSAS, and SQL services.  This makes it possible for a non-technical user to perform Self-Service BI.

This platform also allows with a SINGLE Report and Datasource, unlimited number of users with unique security requirements to be served with customized data and reports. 

Comments (0) Number of views (14760) Article rating: No rating
RSS
12