on 10-23-2009 3:53 PM
Hi,
I have multiple cotext in universe, i want to avoid users being prompted for it.
Is it possible to define predefined condition and apply it on a class to avoid getting context selection prompt.
Could someone share more insight on this.
Thanks,
Rahul
Hi,
As per my knowledge run the report by selecting any context at first time then from next time onwards it won't ask for any context.
Cheers,
Suresh Aluri.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi suresh,
Thank you for your reply.
Is it possible to set Predefined condition on a Join to avoid context being prompted?
I will give u my scenario.
I have 3 loops -
Account Executive
Account Owner
COntact Person
All these 3 loops refer Organization and Contact Tables with few join differences, I have created 3 classes for each of the above and i was wondering if i can set any predefined condition with a explicit Join to force use of a particular context.
I am just wondering if this would be the correct approach.
Also i am getting incompatible objects error as well.
Please share your thoughts.
Thanks,
I am sure there is no book which can teach you the best construct of a context because it is requriement specific.
But in your case, if the users are getting the option to choose among the context, I would first see if in the universe parameter -> SQL -> Allow selection of multiple sql is not checked.
Secondly, incompatible result is not acceptible so you will have to avoid it somehow.
Cheers.
Hi Panan,
Thanks for your reply.
Did you mean , slection of multiple SQL statements per context - this should be non checked?
In this case what will happen if users pull objects from two different contexts.
Also what are the various ways to enforce selection of a particular context?
Objects which are incompatible now belong to different context, any ideas how i can avoid this.
Pls let m eknow
Thanks,
Hi,
If possible create aliases for the tables and then create separate contexts. This would avoid the confusion of customers for the selection of context being prompted at the run time.
Also once you merge the dimensions at the report level from two different DPs (One for each context) will solve your incompatible objects problem.
what will happen if users pull objects from two different contexts.
Two different queries (SQLs) will be formed even if you pull all the objects in one data provider. Thes two sqls must be synchronised else you will get the objects incompatible error.
Regards,
Rohit
If there are other ways to do so please share them as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.