Is that possible to Insert and Update a record in the
Database through Microstrategy..?
Answers were Sorted based on User's Feedback
Answer / preeja
you can update or insert by putting the update/insert
statement in post or pre sql of the report
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / radhakrishna
Yes IT can be acheived by using VLDB Properties of a report.
Using Pre/POST SQL statements you can insert or update the
data in a database.
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / jayesh malviya
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
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / anonymous coward
I'm looking for something similar in feature as
well...anyone know the answer to this?
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / supriya
through Vldb pre nd post insert statements , we can do that.
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
Answer / praveen
Insert and Updating a record can be done Through
transactions services.
This new feature is implemented in microstrategy 9.2.1
version.
Is This Answer Correct ? | 1 Yes | 1 No |
Explain md doctor?
what is the difference b/w the public object&schema object
Explain scan md?
How would you get two images on microstrategy login page?
What is transformation metric in microstrategy?
Explain clustering?
What is microstrategy?
What is report as filter in microstrategy?
What is derived metric?
How do users receive only information that they want?
To save time, can many reports be run at the same time?
What is an i-server?