Question
Is that possible to Insert and Update a record in the
Database through Microstrategy..?
Question Submitted By :: Rajbharath
I also faced this Question!!
Rank
Answer Posted By
Re: Is that possible to Insert and Update a record in the
Database through Microstrategy..?
Answer
# 1
I'm looking for something similar in feature as
well...anyone know the answer to this?
Anonymous Coward
Re: Is that possible to Insert and Update a record in the
Database through Microstrategy..?
Answer
# 2
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
Jayesh Malviya
Re: Is that possible to Insert and Update a record in the
Database through Microstrategy..?
Answer
# 3
you can update or insert by putting the update/insert
statement in post or pre sql of the report
Preeja
Re: Is that possible to Insert and Update a record in the
Database through Microstrategy..?
Answer
# 4
CAn be done in Query Builder
Srydhar
Re: Is that possible to Insert and Update a record in the
Database through Microstrategy..?
Answer
# 5
Hi ,
we can do this with microstrategy office. import the report
in excel , write a macro to update or delete or insert.this
will work fine. i have try it...
Priya Balakrishnan
Re: Is that possible to Insert and Update a record in the
Database through Microstrategy..?
Answer
# 6
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.
Radhakrishna