Microstrategy Security filter Mapping details - Metadata Scripts

-

How to get Security filter Mapping details using Metadata Scripts?


select OI.Object_name,OI1.Object_name,OI1.project_id from DSSMDOBJINFO OI join 
(select I.Object_id A, I1.Object_id B,I.project_id C from DSSMDLNKITEM I
join DSSMDLNKITEM I1
on I.Linkitem_id=I1.Linkitem_id
where I.Link_id in (select Object_id from DSSMDOBJINFO where object_type=52 and Object_name='MD Security filter Link'
and project_id in (select Object_id from DSSMDOBJINFO where Object_name in ('Project name 1','Project name 2') and object_type=32))
and I.project_id in (select Object_id from DSSMDOBJINFO where Object_name in ('Project name 1','Project name 2') and object_type=32)
And I1.Object_type= 34
And I.Object_type=58) LI 
on OI.Object_id=LI.B
join DSSMDOBJINFO OI1
on OI1.Object_id=LI.A
and OI1.Project_id=LI.C

Comments

  1. J.V.27 July 2014 at 06:05

    Hi, i am a begginer in Microstrategy

    I am working with microstrategy ver 9.4.1

    I have installed the product, activated and my intelligence server ir running.

    I have created a project and my project has a database instance.

    I want to create schema objects like attributes or facts, but the option is disabled. I can't do anything related with schema, also 'warhouse catalog' is disabled.

    Any advice will be greatly apreciatted

    Yolanda.

    ReplyDelete
  2. Unknown8 January 2016 at 05:14

    Thanks for giving Good Example.
    Fantastic article, Viral. Very well written, clear and concise. One of the best links explaining one to many and hierarchy in microstrategy. Thanks a lot.It is uaefull to me and my training Ithubonlineonlinetraining center.

    ReplyDelete
  3. Unknown31 January 2016 at 22:55

    Thanks for giving Good Example.
    Fantastic article, Viral. Very well written, clear and concise. One of the best links explaining one to many and hierarchy Microstrategy. Thanks a lot.It is uaefull to me and my training Microstrategyonlinetraining center.

    ReplyDelete
  4. Unknown24 February 2016 at 04:41


    Thanks for Information about Microstrategy Online Training

    ReplyDelete

Post a Comment

Popular posts from this blog

Intelligent cubes in Microstrategy

-
Intelligent Cubes: Topics: Intelligent cubes Intelligent cubes Vs Cache Manage and Monitoring cubes Cube Size and Memory usage Accessing Intelligent cubes Dynamic sourcing Intelligent cube & Security filters Intelligent cubes & Multi-tenant Architecture Intelligent cubes & Level Metrics Intelligent cube is an OLAP feature introduced in Microstrategy 9 version.  Intelligent cube is a pre aggregated set of data stored in intelligent server memory and it will give very quick access to the data without hitting the data warehouse. It is very simple to create an intelligent cube, it is same like a report creation. When we create and publish intelligent cube, it stores all the data in intelligent server memory as well as a copy in file system (secondary storage area -Hard disk). Whenever it reboots, it loads the data to memory from the file ·           Stores data in intelligent server memory and in disk We have two ways to access th
Read more

Useful Metadata Queries - Microstrategy

-
Object ID in MSTR 9.2: Object id in MSTR 9.2 metadata tables has been stored as Unique identifier. So we cannot use Metadata object id in MSTR Desktop and vice versa. But we have a built in functions to convert this. MSTR Metadata Object ID to Desktop Object ID: dbo.fn_UniqueidentifierToCharMsTR () MSTR Desktop Object ID to MSTR Metadata Object ID dbo.fn_CharToUniqueidentifier() Metadata query to get user and group details Excluding Everyone group: select GROUPNAME . object_name [Customer_group] , USERNAME . object_name [User_name] from dbo . DSSMDOBJINFO GROUPNAME       join             ( select object_name , OBJDEPN . depn_objid from dbo . DSSMDOBJINFO b                     join                     ( select distinct Object_id , depn_objid from dbo . DSSMDOBJDEPN                      where object_id in ( select object_id from dbo . DSSMDUSRACCT where isgroup = 0 )                      and depn_obji
Read more

Microstrategy OLAP - Dynamic Aggregation

-
Dynamic Aggregation: When you create a report, MSTR SQL engine writes a SQL in a report level and calculates all the metric values added in the report. After report creation and execution, you have two different options in all objects added in the report. a) Remove from report b) Remove from grid  - Dynamic aggregation Remove From Report: Right Click on any attribute and give "Remove from report" then MSTR SQL engine will rewrite the SQL in the new level and calculate all the values Remove from Grid: Right Click on any attribute and give "Remove from grid" (Still that object present in the report object and only removed from the grid) - In this case, No changes in the SQL. MSTR Analytical engine will calculate all metric aggregation based on the new level in the grid  - This is called DYNAMIC AGGREGATION   In simple terms, MSTR analytical engine dynamically aggregates and calculates all metric values when you remove any attribute from the grid How
Read more