Micro Strategy

Dataset Contains attributes,metrics of the particular Report Only.

Fileset Contains total tables and information

Yes

Open Warehouse Catelog from Architect.Select that particular

DSN.Then it will display available tables in that DSN.Select

the particular table and right click on that,select SHOW

SAMPLE DATA.then it will show sample data in that data set.

1)If in this question we want to deal with null in MSTR

report than we have some display property in report data

option which we can change according to the replacement of

null values.

DATA>>REPORT DATA OPTION>>DISPLAY>>NULL VALUES

2)if we want to deal with sql geration of report than there

is an option of VLDB property according to you requirment u

can deal with sql query of report.

Go to tables in the MSTR .,select the table which u want

to increase the logical size dbl click on the table in the

table editor at the bottom you have option Logical size

there increase logical size and check preserve logical size

when updating schema

difference between schema objects n public objects is

schema objects can be created by using architect permission

and public objects can be created in desktop and by using

schema objects only we can create public objects. schema

obj ex is attributes, facts,hierachies, transpermations

public objects ex is metrics, filters,prompts and so on.

explain the difference between documents and dashboards in mstr your self

we can create only derived metrics in document

by click insert-> new metric

Consolidations :

Consolidations are used to Specify the data you want to view in your report,and it allows you to group attribute elements in New ways without changing the metadata and warehouse definitions.

Use:

When the client want to view profit values as per season wise for a particular region, in this situation season attribute not available in data so we can create the season consolidation as SEASON = {(SUMMER = FEB+MAR+APR+MAY)+ (SPRINT = JUNE+JULY+AUGUST+SEPTEMBER) + (WINTER = OCTOBER+NOVEMBER+DECEMBER+JAN) };

The above consolidation we can insert into report then it will displays the season wise profit values.....

Intelligent Cubes can be created in microstrategy in public

objects folder or in a particular user folder. We can create

a report and point the report to a cube or right click in a

folder and click on cube option to create a new cube. once

the cube is created, choose the report objects (attributes

and metrics) which is required and save the cube. once the

cube is saved and ran to check without any errors, one can

create multiple reports out of a cube. also, you can add new

attributes and metrics when ever necessary and those will be

readily available when you run the reports next time.

Element cache:

Most recently used lookup table elements that are stored in

memory on the intelligence server or MSTR desktop machines.

So they can be retrieved more quickly.

Example:

When a user runs a Prompted report containing an attribute

element Prompt or a hierarchy prompt,an element is created...

We can create number of project sources in Metadata.

But we can access one project source at a time in Microstrategy 8x.

Apply specfic filter condition then after we can get the

report data set. it is olap. view filter main use viewing

purpose for custmoers.

we can use alias name of that table and change the logical

size of that alias table dnt modifies main table and use the

alias table..

Static prompted reports :-

when report is executed and than we saved that report than

it become static with those prompt.

it means when report executed again than it will not ask for

the promts which are present in it.

you can do so by ODBC test tool one of the component of

microstrategy through wich u can update delete or even alter

the table specification as per your need

developer should know follow things:

i)how to create public objects(metrics,filters...ect)

ii)how to create shema objects(attributes,facts)

iii)how to trouble shoot reports/dashboards

Besides these if a candidate how to write and execute system

test case is well and good :)

VLDB properties allow you to customize the SQL that

MicroStrategy generates, and determine how data is

processed by the Analytical Engine.

Eg: if you want to display top 5, 10 or 15 ranks.

1.Create a value prompt which will prompt the user to enter

the value( to display top n rankers)

2. create a filter to calculate rank and in value field

just drag and drop the prompt created above.

Prompt will be tagged to the filter and user will be

prompted during execution. Depending on the input provided

by the user top n rankers will be displayed

You can do it without using value prompt with below steps.

Create a filter on day attribute qualified on ID operator >

and set value to resolve dynamically today – last 10 days.

Standard filtering allows the report filter to affect the

metric.

Absolute filtering raises the report filter to the level of

the target, so all subcategories in the categories included

on the report are added together.

Ignore filtering disregards filtering criteria based on the

attribute in the target and its related attributes (both

parents and children).