Tranformation tables in MSTR

sanvalys · **Joined:** Wed Mar 24, 2010 12:59 am **Posts:** 2

Hi,

Can anybody tell me a method or provide me a sql script to load transofmation tbls like MTD,QTD,YTD into the database(SQL server preffered).

Or can it be done by putting on a view on date table?

Thank you

ashish · **Joined:** Fri Aug 22, 2008 1:41 pm **Posts:** 210

If the tables are in warehouse, you can simply import using WH Catalog.

You can create custom tables based on other tables. Please be more specific about your requirement.

sanvalys · **Joined:** Wed Mar 24, 2010 12:59 am **Posts:** 2

Thank you for your reply.
I do not have transformation table in WH. I need help to create some custom transormations table in WH database and pull them into warehouse catalog in mstr/

Thank you.
Sonny

MicroStrategy Forum

Tranformation tables in MSTR