sunil singh


{ City } bangalore
< Country > india
* Profession *
User No # 85192
Total Questions Posted # 0
Total Answers Posted # 8

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 34
Users Marked my Answers as Wrong # 5
Questions / { sunil singh }
Questions Answers Category Views Company eMail




Answers / { sunil singh }

Question { Tech Mahindra, 21939 }

In Microstrategy, what are Logical Views used for?


Answer

Well both answers are right( from tiru and nadia) same thing just differ in approach.

EX: if there is any table with such feilds

say
day_id, Qtr_id, Qtr_desc, Month_id, Month_desc.

2nd table sales
001 ...090 has same sales ..say 100

now if you are calculating sales over day
it will return you wrong data, by doing 90 days *100 sales values (this is termed as multiple counting problem)

so here we developer are facilitate by this logical table object. we create a new table with proper qtr_id and qtr_desc with sales to get the accurate data every time.
Which will thus be called as aggregated sales data.

This is not recommended until and unless you dont find any other way since performance is your high priority.

Is This Answer Correct ?    3 Yes 3 No

Question { Lanco, 19571 }

In Microstrategy, how can you direct the sql generated to
use a specifc table?


Answer

Totally agree Preeja's answer...but when you have more then
one fact table and they all are hitting some other attribute
you will have take VLDB prop under consideration.

changing the logical size never recommended unless you full knowledge of architect and expertise.
It will create some problem in other reports.

Is This Answer Correct ?    1 Yes 0 No


Question { 21345 }

Is that possible to Insert and Update a record in the
Database through Microstrategy..?


Answer

Yes, we can update the tables in warehouse using microstrategy.
There are few ways..
1) Start- all programs - microstrategy -Tools -DB Queries
There we can write the SQL queries accordingly to get the change in datawarehoouse.

2) Data marting can be some times very helpfull in this situation( its just alternate way but not recomended )

Is This Answer Correct ?    0 Yes 0 No

Question { Infosys, 37727 }

what are the roles & responsibilities of microstrategy
developer?


Answer

Role of developer in MSTR is different in different in evry company.
Its totally in the hand of admin.

IF you are a report developer: you are allowed to used all the public object and schema object but
you can only create public objects as per the requirement.

but according to MSTR itself developer is one who create all the schema and public objects and at the end he come up with
one good report.

Is This Answer Correct ?    7 Yes 0 No

Question { 13002 }

How to do performance tuning on reports.


Answer

For performance tuning there some areas where you need to look and work accordingly.

like
1) is there sufficient space so that MSTR can create temporary tables.
2)proper filtering condition.
3)proper joining between required tables.
4) VLDB property
5)optimization (manual, logical and global)

its better if go go in the same order....

Is This Answer Correct ?    5 Yes 1 No

Question { Marlabs, 10237 }

what is view filter


Answer

view filter is nothing but simple filtering condition but used only when,
a report is executed and some data is being returned. In other words you are just applying filter over the view of data. This is one of the very useful olap property.

EX:
you are developing a report with country and sales

data are some what...

india 1000m
US 10000m
china 8000m

now you just want to view only one country and sale of it.
so, just apply a filter over that executed report.

then it just return like
India 1000m

keep in mind that it will have no effect over the executed SQL in earlier report.
IT will also increase the process and Interaction with client will good.

Is This Answer Correct ?    1 Yes 0 No

Question { TCS, 17781 }

what is the difference b/w the public object&schema object


Answer

Well both the above answers are correct, they both told one one part.

Schema OBJ: those object which are being accessed by the architect only which is granted by the admin. and in the formation of basic architect of any project they play very important role, as they directly deals with the structure and data information in back-end i.e data warehouse. this one reason why we have to update them once changed.

where as

Public OBJ: they are accessed by the report developer only but as per requirement admin may grant you access in schema obj as well. These object are generally used to develop any report since they are not playing any role in architect of the project or the basic object so they dont't required update if any changes are done. public objects are generally created over the schema obj.

Is This Answer Correct ?    13 Yes 0 No

Question { DBS, 14717 }

WHAT IS FACT LESS FACT TABLE?


Answer

Fact-less fact is a type of fact.
and
FACT is business value indicator or measure which are generally in number

but you can not deny that there are some fact which are not
being represented in numeric values.
best EX: attendance sheet in class when we were kid teacher use to write
A- absent
P-present

and at the end of the of year they use to give our attendance in percentage.


and such fact are fact-less fact we can perform over them as well in MSTR.

Is This Answer Correct ?    4 Yes 1 No