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
Posts: 3
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
    Posts: 3
    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
      Posts: 3
      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.