Latest News

Monday, May 12, 2014

OBIEE 12c or OBIEE 11g : Using multiple value for a presentation variable in Criteria

We have a multi select prompt which is initialising a presentation variable (which is a string). When we use this presentation variable in a column formula using a FILTER and IN operator it results in no Result.

FILTER("HR Facts"."Headcounts" USING "Location"."Region Name" IN ('@{pv_region}{West}'))



When ever multiple values are selected in the prompt the SQL being generated by OBIEE Server results as below-
"Location"."Region Name" IN ('East Africa, New Delhi, Central India')


Which results in No Result since there is no region like 'East Africa, New Delhi, Central India' exists in the DB.  But we want OBIEE Server to generate SQL as below

"Location"."Region Name" IN ('East Africa','New Delhi','Central India')

To achieve it use below syntax for Presentation Variable :

FILTER("HR Facts"."Headcounts" USING "Location"."Region Name" IN (@{pv_region}['@']{'West '}))





  • Google+
  • Pinterest
« PREV
NEXT »

74 comments

  1. Nice information. Our institute Is the Leading online institute in

    Hyderabad, India to provide OBIEE online trainings with the real

    time experts and certified professionals. alot

    Obiee Online Training.

    ReplyDelete
    Replies
    1. I feel this is among the such a lot vital info for me. And i am satisfied studying your article. However wanna commentary on few general things, The website style is ideal, the articles is truly nice
      Tangki Panel
      Tangki Fiberglass
      Jual Septic Tank

      Delete
  2. SAP HANA Online Training Hyderabad. Best online training institute for SAP Hana. Get your demo now for free of cost.

    ReplyDelete
  3. Thanks for InformationFlax IT online training began online training for Software program and SAP courses. Online training is the better option to study software products as well as programs, which are SAP modules, like SAP HR, SAP FSCM, SAP BASIS, SAP ABAP, SAP BW, SAP ED ADMIN, SAP SECURITY, SAP SRM, SAP SCM, SAP GRC etc., and Software Courses like JAVA-J2EE, PeopleSoft, Tibco courses, Microsoft Courses, Network and System Admin, Oracle Courses, SAS, Testingtools, PMP, Cognos, AB Initio, ORACLE and Database etc..

    ReplyDelete
  4. Thank you sir,It is nice and more informative. We are providing online training on & for more info: sap wm online training it gives the career plan. It is in simple language and understandable to all freshers.

    ReplyDelete
  5. Thank you sir,It is nice and more informative. We are providing online training on & for more info: sap sd online training it gives the career plan. It is in simple language and understandable to every freshers

    ReplyDelete
  6. wonderful information, I had come to know about your blog from my friend nandu , hyderabad,i have read atleast 7 posts of yours by now, and let me tell you, your website gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a ton once again,
    Regards, obiee training in hyderabad

    ReplyDelete
  7. really good piece of information, I had come to know about your site from my friend shubodh, kolkatta,i have read atleast nine posts of yours by now, and let me tell you, your site gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a lot once again, Regards, obiee training in hyderabad

    ReplyDelete
  8. This comment has been removed by the author.

    ReplyDelete
  9. Thanks for this useful information. This also worked in prompt SQL. I was using LOCATE function in sql to achieve same.

    ReplyDelete
  10. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
    Regards,
    sas training in Chennai|sas course in Chennai

    ReplyDelete

  11. The information you have given here is truly helpful to me. CCNA- It’s a certification program based on routing & switching for starting level network engineers that helps improve your investment in knowledge of networking & increase the value of employer’s network...
    Regards,
    ccna training in Chennai|ccna course in Velachery|ccna training institute in Chennai

    ReplyDelete
  12. Thanks for sharing this niche useful informative post to our knowledge, Actually SAP is ERP software that can be used in many companies for their day to day business activities it has great scope in future.
    Regards,
    SAP courses in chennai|SAP institutes in chennai|sap training in Chennai|sap course in Chennai

    ReplyDelete
  13. This is my first time visit on your site and i have bookmark this for again visit. thanks a lot of for share a appreciable post ..
    sas online training

    ReplyDelete
  14. Thank you very much! I had tried a million ways.
    Cheers

    ReplyDelete
  15. interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts,Thanks a million once again, Regards sap hana training in hyderabad

    ReplyDelete
  16. I really enjoyed while reading this post.The information that you have shared is really great.If anyone interested to do a SAS course then joinfita to choose your better career. Joinfita offers a good training with experienced professionals.
    Regards,
    SAS Training chennai

    ReplyDelete
  17. My Arcus offer java training with 100% placement. Our java training course that includes fundamentals and advance java training program with high priority jobs. java j2ee training with placement having more exposure in most of the industry nowadays in depth manner of java .

    java training in chennai

    ReplyDelete
  18. I had recently visited to this site and found it to be very nice. Thanks a lot for the wonderful site. It was very useful for me. I really appreciate the work.SAP Simple Finance Online Training

    ReplyDelete
  19. we are offering best Obiee online training with work support and job assistance and high quality training facilities and well expert faculty
    for other details and register your demo contact
    obiee training in hyderabad

    ReplyDelete
  20. Truly an awesome post.Keep up your astonishing work and continue sharing.
    Hadoop Training in Chennai

    ReplyDelete
  21. I am not sure that where you are getting this ideas.I have read it fully and it is really awesome. Thanks for your wonderful information.
    ccna Training in Chennai | ccna courses in Chennai | ccna institutes in Velachery

    ReplyDelete
  22. Thanks for sharing your creative ideas.It is really helpful and informative.Keep sharing more with efficient new like this.
    SAS Training in Chennai | SAS Course in Chennai

    ReplyDelete
  23. Updating with the latest technology and implementing it is the only way to survive in our niche. Thanks for making me this article. You have done a great job by sharing this content in here. Keep writing article like this.
    SAS Training in Chennai | SAS Course in Chennai

    ReplyDelete
  24. A debt of gratitude is in order for taking an ideal opportunity to talk about this, I feel upbeat about it and I adore adapting more about this theme. I utilize your manual for teach my understudies.
    DOTNET Training in Chennai | DOTNET course in Chennai | .net training Chennai | .net course in Chennai

    ReplyDelete
  25. Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    salesforce training in chennai | salesforce training institute in chennai

    ReplyDelete
  26. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    Node JS training in chennai | Node JS training institute in chennai

    ReplyDelete
  27. I saw your site its really good and appreciated.. I got more information from your site. Thanks a lot and Keep on Updating.sap hybris online training

    ReplyDelete
  28. Was a perfect solution for my issue Thank you so much

    ReplyDelete
  29. Much obliged to you for requiring significant investment to give us a portion of the valuable and restrictive data with us.
    Regards,
    ccna Training in Chennai | ccna courses in Velachery | ccna institutes in Velachery

    ReplyDelete
  30. thanks for this information sap hana is the mighty field of sap module and also this is the field where sap consultant are getting high salary package . It is a revolutionary platform that’s best suited for performing real-time analytics,
    and we also provide sap training in bangalore if any one wants training in sap hana then just click here and get detail sap training institutes in bangalore and sap hana training in bangalore

    ReplyDelete
  31. Amazing records, i and allow me to assist you to apprehend, your internet website online gives the top notch and the maximum interesting data. that is virtually the form of records that i have been seeking out, i am already your reader now and i'd regularly be careful with the ultra-current posts, all over again hats off to you! thanks a ton once more, regards, oracle fusion procurement on line schooling some of the oracle fusion procurement in hyderabad. test room education in hyderabad india
    thank for sharing
    oracle fusion procurement online training
    oracle fusion procurement training

    ReplyDelete
  32. Excellent post! The strategy you have posted on this technology helped me to get into the next level and had lot of information in it. SAP Simple Logistic Training in Bangalore

    ReplyDelete
  33. oracle financials sector having huge openings for finance background students. here we have oracle fusion hcm and oracle fusion financials online training institute for all the Indian and foreigner students. we have 10+ years of experience in handling oracle technology
    related projects. we have proven skill in online training and giving job assistance after the training.

    for more information please visit:



    Oracle Fusion HCM Training

    ReplyDelete
  34. You post explain everything in detail and it was very interesting to read. Thank you.
    Web design institute chennai

    ReplyDelete
  35. CALFRE handles oracle fusion financials online training and its modules maintaining classroom based training with the self-paced videos. An expert having ten plus years of self-experience handles the training period through
    online and explains each and every point perfectly. We recently launched our institute in the USA and getting the best reputation over there.



    Oracle fusion Financials Training in hyderabad

    Oracle Fusion Financials online Training in hyderabad

    ReplyDelete
  36. I have read your blog its very attractive and impressive. I like it your blog.

    ES6 Online Training JavaScript Training Courses JavaScript Training Courses | Angular 4 Online Training Angular 4 Online Training

    ReplyDelete
  37. Wow...What an excellent informative blog, really helpful. Thank you so much for sharing such a wonderful post with us.keep updating..
    AWS Certifications in Chennai | AWS Exam Centers in Chennai | AWS Certification Exams in Velachery | AWS Exams in Velachery | AWS Online Exam Center in Velachery

    ReplyDelete
  38. Very informative and interesting blog, it was so good to read and useful to improve my knowledge as updated one,keep updating..This Concepts is very nice Thanks for sharing.
    ISTQB Certification in Chennai | ISTQB Exam Centers in Chennai | Best ISTQB Exams in Velachery

    ReplyDelete
  39. It is really very awesome and wonderful to visit your site.Thanks for sharing your informative blog with us.keep updating such a wonderful post..
    MicroSoft Azure Certification in Chennai | Azure Exam Centers in Velachery | Azure Exam Centers in Madipakkam

    ReplyDelete
  40. Your Blog is really amazing with useful and helpful content for us.Thanks for sharing.keep updating more information.
    Embedded System Training Institute in Chennai | Embedded Training in Velachery | Embedded System Training in Guindy

    ReplyDelete
  41. Excellent Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge.
    Java Training Institute in Chennai | Java Certification Training in Velachery

    ReplyDelete
  42. Thanks for sharing your wonderful information..Its really impressive and informative content..
    AWS Certification Training in Chennai | AWS Training Institute in Chennai | AWS Exam Center in Velachery

    ReplyDelete
  43. Excellent Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge.
    Embedded System Training in Chennai | Embedded Training in Velachery | Embedded Courses in Pallikaranai

    ReplyDelete
  44. This is useful post for me. I learn lot of new information from your article. keep sharing. thank you for share us.
    MCSE Training Institute in Chennai | MCSE Training in Velachery | MCSE Training Center in Chrompet

    ReplyDelete
  45. Thanks for giving nice information from your blog...It's really an amazing post..
    Selenium Training Institute in Chennai | Selenium Training Center in Velachery

    ReplyDelete
  46. It is amazing blog and good information... I was improve my knowledge... Thanks for sharing such a informative and wonderful post...
    Java Training Institute in Chennai | Java Training Center in Velachery | Java Certification Training in Taramani

    ReplyDelete
  47. Thanks for your informative article. Your post helped me to understand the future and career prospects. Keep on updating your blog with such awesome article.
    PCB Designing Training Institute in Chennai | PCB Training in Velachery

    ReplyDelete
  48. Wow...What an excellent informative blog, really helpful. Thank you so much for sharing such a wonderful article with us.keep updating..
    Hadoop Training Institute in Chennai | Hadoop Training in Velachery | Hadoop Training Center in Chennai

    ReplyDelete
  49. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
    Embedded Training Institute in Chennai | Embedded Training in Velachery

    ReplyDelete
  50. This is really too useful and have more ideas from yours. keep sharing many techniques and thanks for sharing the amazing article.
    MatLab Training Institute in Chennai | MatLab Training Center in Velachery

    ReplyDelete
  51. Really nice post. Thank you for sharing your amazing information and informative article,its really useful for us.keep updating such a wonderful blog..
    Embedded Training Institute in Chennai | Embedded Training Center in Velachery

    ReplyDelete
  52. Very informative and interesting blog, it was so good to read and useful to improve my knowledge as updated one,keep updating..This Concepts is very nice Thanks for sharing..
    Selenium Training Institute in Chennai | Selenium Training Center in Velachery | Selenium Courses in T.Nagar

    ReplyDelete
  53. Very informative and interesting blog, it was so good to read and useful to improve my knowledge as updated one,keep updating..This Concepts is very nice Thanks for sharing..
    Selenium Training Institute in Chennai | Selenium Training Center in Velachery | Selenium Courses in T.Nagar

    ReplyDelete
  54. Thanks for sharing your great information..Its really very impressive and informative content.keep updating...
    Linux Certification Training Institute in Chennai | Linux Training in Velachery | Online Linux Training in Madipakkam

    ReplyDelete
  55. Amazing blog. Thank you for sharing. The information you shared is very effective for learners I have got some important suggestions from it..
    Blue Prism Training Institute in Chennai | Blue prism Certification Training in Velachery | Blue Prism Training Center in Adyar

    ReplyDelete
  56. Thank you so much for this nice information. Hope so many people will get aware of this and useful as well. And please keep update like this.

    Big Data Services

    Data Lake Services

    Advanced Analytics Services

    Full Stack Development Services

    ReplyDelete
  57. Pretty article! I found some useful information in your blog, it was amazing to read, thanks for sharing this great content to my vision...
    Embedded Training Institute in Chennai | Embedded Training in Velachery | Embedded Certification Training in Velachery

    ReplyDelete
  58. Thank you so much for posting your amazing article...I really appreciate your work. Keep it up. Great work!...keep updating...
    Cloud Computing Training Institute in Chennai | Cloud Computing Training in Velachery

    ReplyDelete
  59. Excellent blog. Thank you for sharing. The information you shared is very effective for learners I have got some important suggestions from it..
    MatLab Training Institute in Chennai | MatLab Training in Velachery | MatLab Training in Taramani

    ReplyDelete
  60. Useful Information, your blog is sharing unique information....
    Thanks for sharing!!!
    aws Training in Bangalore
    python Training in Bangalore
    hadoop Training in Bangalore
    angular js Training in Bangalore
    bigdata analytics Training in Bangalore.SAP Training in Bangalore

    ReplyDelete
  61. Thanks for sharing this great article! That is very interesting I love reading and I am always searching for informative articles like this..
    Cisco Certification Training in Chennai | Cisco Certification Courses in OMR | Cisco Certification Exams in Velachery

    ReplyDelete
  62. Wow!!..What an excellent informative post, its really useful.Thank you so much for sharing such a awesome article with us.keep updating..
    VMware Certification Training in Chennai | VMware Training Institute in Velachery | VMware Certification Courses in Medavakkam

    ReplyDelete
  63. Amazing blog. Thank you for sharing. The information you shared is very effective for learners I have got some important suggestions from it..
    Embedded System Training Institute in Chennai | Embedded Training in Velachery | Embedded Courses in T.nagar

    ReplyDelete
  64. Great post.Thanks for one marvelous posting! I enjoyed reading it;The information was very useful.Keep the good work going on!!
    Tally Training Institute in Chennai | Tally Training in Velachery | Best Tally Courses in Guindy | Tally Training Center in Pallikaranai

    ReplyDelete
  65. I am reading your post from the beginning,it was so interesting to read & I feel thanks to you for posting such a good blog,keep updates regularly..
    Web Designing and Development Training in Chennai | Web Designing Training Center in Velachery | Web Design Courses in Pallikaranai

    ReplyDelete
  66. Awesome post.. Really you are done a wonderful job.thank for sharing such a wonderful information with us..please keep on updating..
    PCB Designing Training Institute in Chennai | PCB Training Center in Velachery | PCB Design Courses in Thiruvanmiyur

    ReplyDelete