How do you export the whole database?

Sort:
You are not authorized to post a reply.
Author
Messages
TheLawsonator
New Member
Posts: 3
New Member
    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
      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
        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.