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

Answer Posted / sunil

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain fact relation?

578


Explain the various types of filters available.

540


What according to you are the roles and responsibilities of a microstrategy developer?.

599


What is the difference between absolute filtering and standard filtering in microstrategy?

565


How would you get two images on microstrategy login page?

537






You have got the requirement from a client. Explain the technical approach you will take now.

499


What is microstrategy desktop?

571


How do you ensure simultaneous releases across multiple operating systems?

561


Explain fact constellation schema?

570


What is smart metric?

546


Imagine this, you are required to reset the password for all users at a time. How would you do that?

553


What is a logical size of a table and what does it depend on?

538


Explain absolute filter?

577


What are objects? Name different type of objects in microstrategy?

542


What is static prompt in microstrategy?

557