webi prompt context selection

[Former Member]

Dear All,

I encountered a problem.

I migrate 3.1 webi report and universe to 4.1, everything is ok.

But when I refresh webi report with webi intelligence rich client,  context selection prompts, as follows,

what should i do to solve the problem? many thanks!

[Former Member · Accepted solution]

Hello,

You are getting Context Selection Prompt, because joins which are in your Query are part of these Contexts.

You need to finalize the Context for Query and remove joins from Other Contexts so that based on Query SQL it will select only one Context and will not prompt for Context Selection.

Regards,

Sushil Padhye

[Former Member · Accepted solution]

Hi Sushil,

Please give me more details, Thanks

[Former Member · Accepted solution]

Hello,

Reason you are getting Selection for Context is because, you are still having Multiple Path to get the Data as per Query...

I have tried creating same scenario..please see below images..

Now If i select objects from Table L_EMP_DPTM and L_EMP_LEVEL in my query i have two path to get that information.

     - L_EMP_DPT --> L_EMPLOYEE --> F_EMP_LEVEL -> L_EMP_LEVEL

     - L_EMP_DPT --> L_EMPLOYEE --> L_EMP_LEVEL

Hence when i try running Query it will ask me for Selection of Context.

Resolution:

1) Modify the Context so that there will not be multiple path.

OR

2) All the other joins in your DFX apart from which you have selected neither Include or Exclude in Context (Make Natural) the joins.

This will allow BO to choose the Path at run time.

I hope this is correct.

Regards,

Sushil Padhye

[Former Member · Accepted solution]

Hi Sushil,

Thank you very much. 

But I'm a little confused. The report in BO 3.1 is OK, but after migration to  BO 4.1, the problem appears.

Is this a bug of Upgrade Management Tool?

[Former Member · Accepted solution]

Hello,

I guess this is not bug.. still i am not sure on this. In 3.1 environment Report used to save your last Context selection and by default using that Context.

I need to test the same scenario in 3.1 and 4.0 again to find with what is causing different behavior in both environment.

Meanwhile if above solution worked for you can you marked Query as resolved??

Regards,

Sushil Padhye

[former_member45129 · Accepted solution]

I think this is not a Bug !

You need to handle this in Universe itself. Try to understand the Data model and proceed

[Former Member · Accepted solution]

thanks

[Former Member · Accepted solution]

thanks

[former_member567937]

Hi Peiqin Wang,

It depends what data you need in the webi report and which is the best possible way to retrieve it. You need to choose a single path for accessing the required data set. Also, the best approach is selecting the best context for your query.