lundi 9 novembre 2009
Par jb le lundi 9 novembre 2009, 12:10 - Décisionnel
When you want to schedule the processing of SSAS database (using Sql Server
jobs), you have two options :
- create ans SSIS package containing Analysis services tasks & schedule
it.
- Build ans XMLA script & schedule it.
Here we will see how you can build an XML script describing the processing
tasks you want to execute.
Lire la suite...
mercredi 26 août 2009
Par jb le mercredi 26 août 2009, 20:38 - Décisionnel
Usually, when we create a data source in Cognos, it is easier to specify a
connection using Cognos Service Credentials. This means that all connections to
the data source are done using the Cognos service user's profile.
- Advantage of this method is that it needs less setup on the corresponding
database server (only one account).
- Disadvantage is that you cannot make use of "row level security" as all
Cognos users will connect using the same profile (Data source has no
information about current Cognos user).
To take advantage of an eventual user level security setup behind Cognos
data sources, we need to connect using the current Cognos user's profile.
Lire la suite...
Par jb le mercredi 26 août 2009, 07:11 - Décisionnel
Security implementation in Analysis Services
In some cases, companies want to give different level of access to strategic
data, depending on user’s profiles. Analysis services gives us ability to
secure cubes data by building Roles containing security rules, mainly by
filtering dimensions data.
For example, if you have a cube giving Turnover amounts per salesperson,
salesmen should see only the data corresponding to their sales area only. Also,
one manager may want to see data for all areas he’s responsible for.
This document describes how we can achieve security on the sales Area axis for
the sales domain. Notice taht in this example, we are using Cognos as
reporting tool. This addidional layer has no impact on the way we
setup MSAS & Active directory, results will be the same with Microsoft
Reporting services
Lire la suite...
mercredi 23 janvier 2008
Par jb le mercredi 23 janvier 2008, 15:19 - Qui suis-je ?
Jean-Baptiste HEREN, 32 ans. 9 ans d’expérience.
Titre & fonction
Chef de projet Systèmes d'information.
Consultant ERP - Décisionnel - Technos Web
Lire la suite...
une annexe