Zobacz posty bez odpowiedzi | Zobacz aktywne tematy RSSKanał RSS



Odpowiedz  [ 1 post ] 
 How to send MDX query result to a temporary table? 
Autor Wiadomość

Rejestracja: 10 Maj 2017, 08:23
Posty: 260
Post How to send MDX query result to a temporary table?
I´m a newbie on this OLAP stuff. We have an OLAP cube, we make a MDX query to get some information we need. The result of the MDX query are 3 columns, one of them is a calculated member. We run the query and the result is what we want.

Everything is just OK until here, because we need to take that information to a temporary table using a DTS package, but the calculated member is not displayed on the preview, therefore the data of this column (calculated member) is not inserted on the table.

What can I do to get the data into the temporary table including the calculated memeber? Is there some trick to do it thru a DTS package?

Did I give you enough information to help me? Is there some else information you need? Thanks !

I didn't find the right solution from the internet.

References:

http://forums.databasejournal.com/showt ... rary-table

Transportation Management Video Examples


14 Sie 2017, 07:03
Profil
Wyświetl posty z poprzednich:  Sortuj według  
Odpowiedz   [ 1 post ] 

Nie możesz zakładać nowych tematów na tym forum
Nie możesz odpowiadać w tematach na tym forum
Nie możesz edytować swoich postów na tym forum
Nie możesz usuwać swoich postów na tym forum
Nie możesz dodawać załączników na tym forum

Szukaj:
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.

phpBB SEO