ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories >> Software >> Data-Warehouse >> Micro-Strategy
 
 


 

Back to Questions Page
 
Question
what are the roles & responsibilities of microstrategy
developer?
Rank Answer Posted By  
 Question Submitted By :: Laddu
This Interview Question Asked @   Infosys
I also faced this Question!!   © ALL Interview .com
Answer
1  creating attributes and facts 
  2  creating the reports$dashboard and scordboards
  3  creating customer group $ consolidation
  4  creating metric,filter,prompts ,drill maps & free form  
     SQL
  
 
0
"koduri"
 
 
Answer
	Created filters, attributes, compound attributes using the
attribute creation wizard.
	Created facts using fact creation wizard.
	Created prompts and custom groups and consolidation.
	Created test cases as a part of unit testing of the
generated reports.
 
0
Kumar
 
 
Answer
1.creating Schema Objects(facts.attributes)
2.creating Pubilc Objects(metrics,filters 
prompts,reports..etc)
3.creating dashbords for reports.
 
0
Tiru
 
 
 
Question
Is that possible to Insert and Update a record in the 
Database through Microstrategy..?
Rank Answer Posted By  
 Question Submitted By :: Rajbharath
I also faced this Question!!   © ALL Interview .com
Answer
I'm looking for something similar in feature as 
well...anyone know the answer to this?
 
0
Anonymous Coward
 
 
Answer
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
 
0
Jayesh Malviya
 
 
Answer
you can update or insert by putting the update/insert 
statement in post or pre sql of the report
 
0
Preeja
 
 
Question
In Microstrategy, how can you direct the sql generated to 
use a specifc table?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   Lanco
I also faced this Question!!   © ALL Interview .com
Answer
By changing the Logical Size of the "specific" table. After 
changing table size, you need to update schema.
 
1
Kwwl
 
 
Answer
if it is required for metric to calculate from a particular 
table in report, you can try changing the "level"  in the 
merics.
 or by using relationship filter also can direct to a 
particular table ,based on the requirement.

modifying the logical table size is a good idea, but it can 
affect all reports which depends on the attributes defined 
on the same table.
 
0
Preeja
 
 
Question
In Microstrategy, what are Logical Views used for?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   Marlabs
I also faced this Question!!   © ALL Interview .com
Answer
a logical view is a view that u obtain by querying the db 
thru sql. these result can be stored as a table then.
 
0
Pencildot
 
 
Answer
Logical view is just a table(logical table) but it is 
create in deskop by writing our own SQL as per Our 
requirement based on the physical tabes what we import from 
our database.Once if it is create itacts as a physicaltable 
as other phisical tables.
 
0
Tiru
 
 
Question
In Microstrategy, how can you direct the sql generated to 
use a specifc table?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
Using the Level parameter in the Metric level options
 
0
Guest
 
 
Answer
Assuming you have OLAP licence,the easiest way to direct to
a particular table is to create a dummy fact on the
table,include the fact in metric and put the metric in
report objects.
 
0
Andy
 
 
 
Back to Questions Page
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com