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 |
What do you mean by dimensional modeling and relational modeling? Which one do you use in dw? Why?
What are the tracing options available in microstrategy object manager?
What is a conditional attribute in microstrategy?
Explain absolute filter?
What leads to a cross-join or how does a cross-join occur?
what is the difference b/w the public object&schema object
what are the nulls on microstrategy report and how to mask them.
Can reports be executed in off-peak periods?
Which of the end-user items leverage olap services?
A report is taking few seconds to run.The same report is taking very long time on the next day without doing any kind of changes in the report. What could be the reason? how do you tune the report.
What is the difference in the way microstrategy handles custom group and consolidations?
What is scanmd and md doctor?