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 »

150 comments

  1. 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
  2. This comment has been removed by the author.

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

    ReplyDelete
  4. 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
  5. 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
  6. Thank you very much! I had tried a million ways.
    Cheers

    ReplyDelete
  7. 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
  8. 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
  9. 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
  10. Truly an awesome post.Keep up your astonishing work and continue sharing.
    Hadoop Training in Chennai

    ReplyDelete
  11. 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
  12. 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
  13. 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
  14. 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
  15. Was a perfect solution for my issue Thank you so much

    ReplyDelete
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
  21. You post explain everything in detail and it was very interesting to read. Thank you.
    Web design institute chennai

    ReplyDelete
  22. 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
  23. 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
  24. 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
  25. 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
  26. 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
  27. 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
  28. 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
  29. 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
  30. 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
  31. 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
  32. 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
  33. 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
  34. 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
  35. 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
  36. Thanks for making me this Blog. You have done a great job by sharing this content here.Keep writing blog this like.
    MatLab Training Institute in Chennai | MatLab Training Center in Velachery | MatLab Courses in Tambaram

    ReplyDelete
  37. Pretty blog, so many ideas in a single site, thanks for the informative article, keep updating more article.
    Software Testing Training Institute in Chennai | Software Testing Training Institutes in Velachery

    ReplyDelete
  38. I am really enjoying reading your well-written articles. It looks like you spend a lot of effort and time on your blog..
    MCSE Certification Training Institute in Chennai | MCSE Training Center in Velachery

    ReplyDelete
  39. Pretty blog, so many ideas in a single site, thanks for the informative article, keep updating more article.
    Oracle Training Institute in Chennai | Oracle Certification Training in Velachery | Oracle Courses in Pallikaranai

    ReplyDelete
  40. As we know there are many companies which are converting into Google cloud big data services. with the right direction we can definitely predict the future.

    ReplyDelete
  41. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision...
    Java Project Center in Chennai | Java Project Center in Velachery | Java Projects in Velachery

    ReplyDelete
  42. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge.
    VLSI Project Center in Chennai | VLSI Project Center in Velachery | VLSI Projects in Pallikaranai | VLSI Projects in Guindy | VLSI Projects in Taramani

    ReplyDelete
  43. Really Very happy to see this blog. thanks for sharing such a amazing blog...
    Final Year Project Center in Chennai | Final Year Projects in Velachery

    ReplyDelete
  44. This is really very impressive article with useful content,thanks for sharing your amazing post.
    MatLab Project Center in Chennai | MatLab Project Center in Velachery | MatLab projects in Perungudi

    ReplyDelete
  45. Excellent blog with lovely information. really very useful article for us thanks for sharing such a wonderful blog...
    Final Year Project Center in Chennai | Final Year Projects in Velachery

    ReplyDelete
  46. Very interesting, good job and thanks for sharing such blog. It is very interesting to read. Its pretty good and well noted.
    Cloud Computing Project Center in Chennai | Cloud Computing Projects in Velachery

    ReplyDelete
  47. I read this article. I think You put a lot of effort to create this article. I appreciate your work.
    Embedded System Training Institute in Chennai | Embedded Training Center in Velachery | Embedded Training in Guindy

    ReplyDelete
  48. The first point is that ML algorithms can assist people by helping them to find patterns or dependencies, which are not visible by a human. machine learning and ai courses in hyderabad

    ReplyDelete
  49. It is very awesome and wonderful to visit your site.Thanks for sharing this information,this is helpful to me a lot...
    Java Training Institute in Chennai | java Training Center in Velachery | Java Training in Velachery | Online Training Institute in Velachery

    ReplyDelete
  50. Brilliant article. The information I have been searching precisely. It helped me a lot, thanks. Keep coming with more such informative article.
    C and C++ Training Institute in Chennai | C and C++ Training Center in Velachery | C & C++ Training in Velachery | Online Training in Velachery

    ReplyDelete
  51. Excellent post... Thank you for sharing such a informative and information blog with us.keep updating such a wonderful post..
    MicorSoft Azure Training Institute in Chennai | Azure Training Center in Chennai | Azure Certification Training in velachery | Online Azure training in Velachery

    ReplyDelete
  52. Excellent information with unique content and it is very useful to know about the information based on blogs...
    ISTQB Certification Course in Chennai | ISTQB Certification Course in Tharamani

    ReplyDelete
  53. Amazing article. Thanks for sharing such a excellent blog.it is very useful for us.
    PCB Training Institute in Velachery | PCB online training | PCB offline training

    ReplyDelete
  54. Really excellent blog.It is very useful for us. Thaks for for such amazing blog. Keep sharing such excellent blog.
    PMP Certification Center in Chennai | PMP Certification Online Training | PMP Certification Offline Training

    ReplyDelete
  55. Really very nice blog.It is very informative and useful for everyone.Thanks for sharing a wonderful blog.
    AWS Training Institute in Chennai | AWS Online Training Institute in Chennai | AWS Offline Training Institute in Chennai

    ReplyDelete
  56. Really amazing informative blog.Excellent blog with unique content.It is very useful for us.Thanks for

    sharing such a wonderful blog.
    C and C++ Training Institute in Chennai | C and C++ Online Training Institute in Chennai | C and C++ Offline Training Institute in Chennai

    ReplyDelete
  57. Great post! I am actually getting ready to across this information, is very helpful my friend. Also great blog here with all of the valuable information you have. Keep up the good work you are doing here.
    business analytics course

    ReplyDelete
  58. Good 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 Training Institute in Velachery

    ReplyDelete
  59. Your Blog is really an amazing content to read, its very useful for everyone. thanks for sharing such an wonderful post..
    PMP Exam Center in Chennai | PMP Certification in Velachery | PMP Exams in Velachery | Online Certification in Chennai

    ReplyDelete
  60. This is useful post for me. I learn lot of new information from your post. keep sharing. thank you for share us...
    GGRE Test Center in Chennai | GRE Test Center in Velachery | GRE Test in Chennai | Online GRE Exams in Velachery | Online GRE Certification in Velachery

    ReplyDelete
  61. Good information and really its very much useful Blog . Thanks for sharing and keep updating like this …….
    IELTS Exams in Chennai|
    IELTS Exams in Velachery|
    IELTS Exams in Tharamani|
    IELTS Exams in Perungudi|
    IELTS Exams in Thambaram

    ReplyDelete
  62. Very informative blog. Helps to gain knowledge about new concepts and techniques. Thanks a lot for sharing this wonderful blog.keep updating such a excellent post with us.
    PMP Exam Center in Chennai | PMP Certification in Velachery | PMP Online Certification in Chennai | PMP Exams in Chennai | PMP Exams in Chennai

    ReplyDelete
  63. 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.


    Linux Training Institute in Velachery |
    Linux Training Institute in Chennai |
    Linux Training Institute in Tambaram |
    Linux Training Institute in Taramani|
    Linux Training Institute in Medavakkam

    ReplyDelete
  64. Nice post.. Its really an amazing with informative information and useful for everyone. Thanks for sharing your wonderful article..

    AWS Certification in Chennai | AWS Exam Center in Chennai | AWS Exams in Velacheri | AWS Online Exams in Velachery | Online Certification in Chennai

    ReplyDelete
  65. AlltechZSolution in Chennai provides Microsoft Azure Training supplies the advanced stage course equal to the modern IT Industry. Nowadays Microsoft Azure is one of the emerging guides wherein students and specialists are taking on. Microsoft Azure is the business enterprise's public cloud computing carrier that has millions of users globally. It provides exceptional offerings in terms of networking, garage, and analysis. The Scope and opportunities for Microsoft Azure certified aspirants have dramatically increased within the modern-day years, owing to the growing demand through large corporate agencies. It growing the competencies inside the aspirants to transport an existing. Each online and offline training is to be had .NET ASP MVC software to Azure along with its functionality. The rookies will get maintain of the methods to optimize the software program improvement life cycle.

    ReplyDelete
  66. Really Very amazing blog with useful

    information... Thanks for sharing such a nice

    post..

    Final Year Project Center

    in Chennai
    | Final Year Projects in

    Velachery

    ReplyDelete
  67. Nice post... Really you are done a wonderful job. Thanks for sharing such wonderful information with us. Please keep on updating...
    Advanced & Core JAVA Training in Chennai |
    Python Training in Chennai|
    AWS Training in Chennai|
    Certified Ethical Hacking Training in Chennai|

    ReplyDelete
  68. This post is very simple to read and appreciate without leaving any details out. Great work!
    data scientist course in aurangabad

    ReplyDelete
  69. ShiftEasy is India's end to end Real Estate Property Management Platform. Find the Best Property in India, UK & Abroad. Buy/Sell/Rent/Lease your Property with Shifteasy becomes more easy.

    Best Residential Property in India

    ReplyDelete
  70. Excellent goods from you, man. I’ve remember your stuff prior to and you’re just extremely
    fantastic. I really like what you have got right
    here, certainly like what you are stating and the way in which by which you assert it.
    You’re making it entertaining and you still take care of to keep it sensible.
    I cant wait to read much more from you. That is really a wonderful site.

    ReplyDelete
  71. A good blog always comes up with new and exciting information and while reading I have felt that this blog really has all those quality that qualify a blog to be one.Kindly take time to check my Blogs too which is aboutSEO Questions and Answers

    ReplyDelete
  72. Thanks for this awesome blog post....Its very useful and interesting blog articles ......We provide projects for final year matlab projects chennai

    ReplyDelete
  73. Nik Collection by DxO Full Crack Add the power of the Nik Collection by DxO to your workflow today and create stunning images faster. The most .Nik Collection By Dxo V4 30 0 X64

    ReplyDelete
  74. Thank you so much for sharing this information. Do visit free internship in chennai

    ReplyDelete
  75. AllTechZ is the best Search Engine Optimization Training Course in Chennai a term that suggests the development of goodness Web composition upgrade is the demonstration of additional fostering a webpage's arranging in unique web search devices like a Nation individual, Google, Bing, and others picked various watchwords or statutes nearby to the webpage's work or wonderful. Its extra benefits incorporate favored control of districts over updating site traffic and search arranging. We have recorded amazing and first-rate Site improvement arranging foundations in Chennai with every one of the normal subtleties like Course Stake, Plan, Staff, and extensively less. Both are online classes and offline classes available. Presently Alltechz Guides Situation helps moreover.

    ReplyDelete
  76. AllTechZ offered Embedded Training In Chennai. The Embedded Readiness in Chennai at AllTechZ first familiarizes the understudies with the pieces of Embedded System Programming and its headway cycle. The Expert Embedded Mentors at AllTechZ get you acquainted with the Memory System, Cycle Plan, Microcontroller Peripherals, and significant level upgrades and use of the compilers persistently with license. Close to the completion of the Embedded Arrangement in Chennai at AllTechZ, you will end up being more familiar with Embedded System Development, its Applications, and the capacities that are supposed to work as an Introduced Subject matter expert. Online Classes are available. Weekdays and weekend Classes are available.

    ReplyDelete
  77. AllTechZ Offered Photoshop Training In Chennai. The Photoshop Classes in Chennai at AllTechZ is a specialist program that engages even the fledgling to foster their image-making capacities further and make them functional with Photo changing abilities, for instance, adjusting, modifying, various reviews, building covering, and further developing pictures. Around the completion of Photoshop Getting ready in Chennai at AllTechZ, you will sort out some way to make clear, assortment, layers, and thing changes unusually and basically under the mentorship of Master Photoshop experts progressively. Online Classes are Available. Weekdays and Weekend Classes Are Available.

    ReplyDelete
  78. AllTechZ Offered Advanced Excel Training In Chennai. Join Advanced Succeed Getting ready in Chennai at AllTechZ and value the Microsoft Succeed Office suite from its basics to the significant level under the course of Fitness. Succeed Getting ready Framework at AllTechZ enables you to proficiently research the data on any level. It sets you up to use computation sheets with capacities, conditions, and charts, perform data mashups, concentrate or pull the information, envision the eliminated data, turn tables, turn diagrams, test, and Prevail in VBA under the mentorship of asserted specialists.Online Classes Are Available. Weekdays And Weekend Classes are Available

    ReplyDelete