Skip to Content
author's profile photo Former Member
Former Member

BW Flat Cube support for BPC

Dear experts,

We have NW BPC customer where over 13 dimensions are used in some models. BW cube limitation forces BPC to insert BW infoobjects to be stored on last BW dimension so cube read/write performance is poor.

Customer has MS SQL Server 2014 DB and 7.40 NW but as per described in note "2116639 - SQL Server 2014 Columstore Documentation" we cannot use Flat cube in real time (transactional) infocubes.

Can anybody, who has done specific datawarehouse remodeling/repartitioning for NW infocubes for more than 13 dimension, share their experience? Can anyone manage to do Flat Cube model in BPC with eliminating dimension tables like HANA Column based approach in SQL server?

Thanks in advance,

Regards

Ergin Ozturk

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 24, 2016 at 12:16 AM

    Hi Ergin,

    You have 2 options:

    1. Move to HANA where limitation of 13 Dimension is removed

    2. Run a Full optimization of that Model. This will analyze which combination of Dimensions produces smaller DIM tables and re-arrange BPC Dimensions accordingly.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Gregor Dieckmann

      Dear Gregor,

      I agree your points, and in my first message I also mentioned official statement is not supported.

      But there are 3 points:

      1) Flat Cube transition

      2) ColumnStore Index

      3) (In-memory) Columstore Index

      I see reasons why Columstore can not be implemented but I could not understand Flat Cube transition is not allowed since I can create Real-time cube if I create it from scratch.

      I do not expect official statements from people but maybe a guidence or a roadmap document, I guess I may ask for it in this media..

      Thanks

      Ergin


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.