Forums
S3 Interfaces/Conversion
How do you export the whole database?
Author
Messages
TheLawsonator
New Member
Posts: 3
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
Posts: 3
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
Posts: 3
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.