PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/03/2005 1:27 PM by  TheLawsonator
How do you export the whole database?
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
TheLawsonator
New Member
(7 points)
New Member
Posts:3


Send Message:

--
09/29/2005 4: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
    (7 points)
    New Member
    Posts:3


    Send Message:

    --
    10/10/2005 9:49 AM
    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
    (7 points)
    New Member
    Posts:3


    Send Message:

    --
    11/03/2005 1: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.
    You are not authorized to post a reply.