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

Multicube and Bi Acclerator

Hello Gurus,

I have a small doubt.

I have a multiprovider and it has 4 cubes in that out of which 3 are on BIA and 1 is not.

can you please tell me how will be the performance of query output and where all it will look when query is run :--

1. For data from the 3 cubes on BIA.

2. For data from ^2 cubes from BIA and 1 from non BIA.

Kindly let me know.

Regards,

Den

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Apr 09, 2008 at 03:28 PM

    To my understanding, all 4 cubes have to be scanned. If non-BIA indexed cube can be scanned theu indexes (just to check that it does not contain any data for the query) - it will be pretty fast, otherwise it becomes bottle-neck.

    I would recommend you to check if you can use Infoprovider-Specific settings for Characteristics, that allow to avoid scans of part providers.

    Regards,

    -Vitaliy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 09, 2008 at 02:28 PM

    As always it depends.

    But in very simple terms, number 1 will be faster. If you have a multiprovider with any part of it using a non-indexed cube it will run as slow as it takes to run against that slowest cube access.

    Regards,

    Mike Bestvina

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2008 at 12:37 PM

    Answered... Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

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.