This discussion is archived
1 Reply Latest reply: Sep 29, 2013 1:00 AM by Sh!va Branched to a new discussion. RSS

Restructing Essbase Database question

Teddd Newbie
Currently Being Moderated

Hi,

 

We just moved from 11.1.1.4 to 11.1.2.3. We have various cubes and the cube loads are all automated daily. Now in the latest version after the dimension builds and data loading the BSO databases are occupying 5-6 times more space than what we saw in 11.1.1.4 version. Once I restructure the database the database size in 11.1.2.3 gets reduced to database size of 11.1.1.4.

 

My question is why do I have to restructure them manually, we use the same maxl scripts on both the versions and yet one occupies 1gb and the other database occupies 10gb. And since the data loads are a daily process it is getting difficult to restructure them everyday. I know we can use Maxl to restructure but we never had to do that in 11.1.1.4. What changed?

 

Thanks,

Ted.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points