December 3, 2008 at 12:21 am
Hi Guys
We provide a SaaS solution to our clients in a multitenant
architecture and as such we have a OLTP relational database with
clients data all mixed together and split using Client ID fields.
We are looking to add the ability for clients to create SSAS cubes
based on their data but obviously giving them access to the database
using BIDS will give them too much access to the database and also
will go agains the SaaS "no software" paradigm.
Does anyone know hopefully customise the cube, which will allow our customers to create a SSAS data source view and cube based on their data subset?
Thanks,
Regards,
Viji
December 3, 2008 at 9:30 am
You can definitely create a cube (or cubes) via code and this approach allows you to create all of the required objects (e.g. datasource, DSV, dimensions, cubes, KPI's etc etc). Depending on your requirement, you could reasonably easily write up an application that builds a specific cube for each client (assumes a standard set of client requirements and standardized data captured); or alternatively you *could* write up a front end (let's call it a wizard) that your clients run through and you collect the responses and generate a cube (and associated objects) based on this information.
The latter is the basic premise of a tool that I've been involved with that has been successfully implemented with various clients (not SaaS but theoretically possible as it's all web-based).
HTH,
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply