• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization S3 Interfaces/Conversion

How do you export the whole database?

 2 Replies
 0 Subscribed to this topic
 11 Subscribed to this forum
Sort:
Author
Messages
TheLawsonator
New Member Send Private Message
Posts: 0
New Member
9/29/2005 8:01 PM
Is there a way to export the Lawson database in its entirety without going datamart-by-datamart?

I'm trying to export all the corporate Lawson data into an ASCII star schema but am only able to extract one mart at a time.

Does anyone know a way within Analytic Architect (or otherwise) to extract all the tables and structures at once into an ASCII star schema? (So I can load it into Oracle, we do not use Essbase or Microsoft Analyis Service).

Thanks in advance.
TheLawsonator
New Member Send Private Message
Posts: 0
New Member
10/10/2005 1:49 PM
In AA seems like you're stuck with either aggregating to N-dimensions or setting up dimensions that don't really aggregate to get to the granular data.
TheLawsonator
New Member Send Private Message
Posts: 0
New Member
11/3/2005 6:27 PM
To bring this to closure I'll share that I finally spoke with a Lawson consultant and they confirmed that AA is not meant to export granular data but rather summarized marts and added that even if one were to create a mega-mart of all the dimensions and all the facts the volume would cause AA to run slower than Xmas or lock up.