Is that possible to Insert and Update a record in the Database through Microst

Categories >> Software >> Data Warehouse >> Micro Strategy
Suggest New Category

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

Question Posted / rajbharath

11 Answers
21424 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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

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

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

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

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

Answer / vinod

Yes, it can be done using transaction services.

Is This Answer Correct ?

5 Yes

0 No

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

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

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

Answer / supriya

through Vldb pre nd post insert statements , we can do that.

Is This Answer Correct ?

1 Yes

0 No

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

Answer / 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

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

Answer / kk

We have to use freeform sql in MSTR

Is This Answer Correct ?

0 Yes

0 No

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

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

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

Answer / srydhar

CAn be done in Query Builder

Is This Answer Correct ?

0 Yes

2 No

Post New Answer