Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Open World, Portal & Decision Manager

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
33%
Installation Wizard into new VRC
39%
Manual into existing VRC
6%
Manual into new VRC
22%
Total votes: 49

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th July 2003, 15:58
BisBoy BisBoy is offline
Junior Member
 
Join Date: Jul 2003
Location: UK
Posts: 3
BisBoy is on a distinguished road
Baan: 5 - DB: Oracle - OS: AIX, NT 4
OLAP 64000 limitation

Hi,

We've come across a limitation in OLAP cubes that only allows 64000 children for a single parent in a dimension (OLAP 7.0 SP2).

Currently to fix this we either need to delete the dimension or re-structure it. ie. identify and add new levels to split the data into smaller categories

We believe from various documentation that this issue may be fixed by upgrading to SQL 2000 and Analysis Services .. there is some kind of fudge that allows a dimension to be linked to iteslf ??

Has anybody come across this problem and resolved it within either OLAP 7.0 or Analysis Services ?

If there is a fix in Analysis Services, is it fairly straight forward to implement ?

Any assistance in this would be greatly appreciated.

Thanks
Reply With Quote
Sponsored Links
  #2  
Old 11th July 2003, 09:41
robertvg's Avatar
robertvg robertvg is offline
Senior Member
 
Join Date: Nov 2002
Location: Hoofddorp / The Netherlands
Posts: 164
robertvg is on a distinguished road
Baan: BaaN IVc4, 5.0c - DB: Oracle 8.1.7 - OS: HP-UX 11.11
AS2K has a grouping level feature that lets you create a hidden level between the database's parent members and children, so you can work around the 64,000 member limit.
See: http://support.microsoft.com/support.../q303/9/69.asp

In SQL7 you would need to add a higher level in the existing dimension.

R.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sales Statistics limitation herdyx Distribution, Transportation & Warehousing 0 25th August 2003 10:59


All times are GMT +2. The time now is 22:59.


©2001-2018 - Baanboard.com - Baanforums.com