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
Explain attribute role?
What are intelligent cubes?
suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?
Can you create an event based schedule in microstrategy? How?
What are the different types of mstr objects?
Explain standard filters?
How do you achieve schema object version control?
Difference between project merge and object manager in microstrategy?
Name the types of transformation?
can metadata be manually edited? If yes, how?
What do you mean by inmon?
What are the vldb properties? Which level of vldb configurations have the highest precedence?
How to use consolidations in microstrategy report?
Write different kinds of objects in microstrategy?
Now, imagine this, you come across a situation where an aggregate table at higher level has a higher lts than the one at lower level. A.) What problems can you anticipate? B.) How would you solve the problem.