OBIEE 10G/11G - How to set a presentation variable ?

Table of contents, articles related, multiple value / select, dashboard prompt, variable prompt, with javascript.

You can set up a presentation variable:

  • only through the user interface
  • programmatically with javascript is not yet supported

And you can use it then in many places : OBIEE - Where can I use a presentation variable ?

OBIEE 10G/11G - The (dashboard|column) prompt

Obiee - presentation variables, obiee - topn, obiee - where can i use a presentation variable .

Which means:

How to set it up

With the user interface.

In 10G, the dashboard prompt is the only way to set a presentation variable . With the advent of 11G, you can now set a presentation variable with the help of a variable prompt

When the dashboard or variable prompt is used in a dashboard, the variable is simply set with the new value.

When you create a dashboard prompt, you have in the column “set variable” the choice between two values :

variable prompt

This functionality does not exist at the moment.: OBIEE 11g: How To Set the Value of a Presentation Variable Using Javascript

Recommended Pages

Share this page:

Data (State) Data (State) DataBase Data Processing Data Quality Data Structure Data Type Data Warehouse Data Visualization Data Partition Data Persistence Data Concurrency

Data Science Data Analysis Statistics Data Science Linear Algebra Mathematics Trigonometry

Modeling Process Logical Data Modeling Relational Modeling Dimensional Modeling Automata

Data Type Number Time Text Collection Relation (Table) Cube Tree Key/Value Graph Spatial Color Log

Measure Levels Order Nominal Discrete Distance Ratio

Code Compiler Lexical Parser Grammar Function Testing Debugging Shipping Data Type Versioning Design Pattern

Infrastructure Operating System Monitoring Cryptography Security File System Network Process (Thread) Computer Infra As Code

Marketing Advertising Analytics Email

Web Html Dom Http Url Css Javascript Selector Browser Web Services OAuth

Contact [email protected] Privacy Policy Status

use of presentation variable in obiee 11g

DATAWAREHOUSE CONCEPTS

A blog where you can explore everything about Datawarehouse, OBIEE, Informatica, Power BI, QlikView, Hadoop, Oracle SQL-PLSQL, Cognos and much more....

Monday, 15 October 2012

Presentation variable in obiee.

No comments:

Post a comment.

Sandeep Venu

Tips and tricks, blog archive.

Enter key word

Using presentation variable with all column values or no default value option in obiee 11g.

use of presentation variable in obiee 11g

About Unknown

Related posts, 4 comments:.

Thanks for Information OBIEE11g Online Training

Thanks for Information Flax 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..

Thanks for writing this article. your analysis is very logical. For those who are new and want to learn more about Obiee 11 may visit this page- https://intellipaat.com/oracle-obiee-training/

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

Post a Comment

Real World OBIEE: Demystification of Variables Pt. 1

Matthew Walding

Matthew Walding

OBIEE has some very powerful features and capabilities when it comes to how we visualize and present our data. There are some features which almost everyone uses (filters, prompts, rename columns ect.) and then some that are less common. In part, I think there is a lot of "noise" that surrounds the explanation of some of these features. Another reason, and probably the most likely, is that a lot of report developers may just don't know that they exist. I can't tell you how many times in one of our training courses here at Rittman Mead that someone says "wow, I didn't know I could do that!" or that I get asked, "could you explain how Presentation Variables work?". Now, I am not saying that there is anything wrong with not knowing or being confused when it comes to some of the features in OBIEE. In fact, it's my main purpose in writing this blog series! I want to demystify and show you some of the features and techniques I have used with almost every client I have worked with. Even if you are a seasoned veteran, my goal is to present something in a way that you haven't heard before and spark some ideas in your day-to-day development. So with all of that said, let's dive into part one of the Demystification of Variables.

For the first part of this series, I want to talk about using Bins and Presentation Variables together at a report level and also in dashboard prompts. Before we dive into an example, let me talk a little bit about bins and presentation variables.

Sometimes we need to group values differently than what we have available from our column selection. Common examples could be when we need to group products differently than product category, when we need to create a group for items on sale or, maybe the most common I've seen, when we need to create custom groups for certain values and then have a group for the "others". Creating custom groups can be accomplished in a few different ways (selection steps, add new group from the Results tab), but the way I'm going to show you involves using the Bins tab under Edit formula within a column. I'll go over this process shortly when we dive into the example.

Presentation Variables

These are one of the most powerful features in Answers. They are also one of the things that trip people up the most. Think of presentation variables like placeholders and these placeholders are waiting for a value or a group of values to be passed into them. There are really only three parts to the presentation variables we will look at in this example: First you assign the presentation variable (give it a name) in a prompt to pass the value or group of values selected into the second part. The second part is where the placeholder (presentation variable with the same name) is put in a column formula, column heading, text object etc. The third part is called formatting. Formatting is used when you need to apply a certain format to the values coming into the presentation variable placeholder. There are a massive amount of use cases for presentation variables but I am going to cover only a couple of the ones that I've used the most.

Make sense? If you're still a little confused or hearing about this for the first time, don't worry. We are going to go through an example that I hope will explain the uses of Bins and Presentation Variables in a way that is concise and clear.

Now, lets dive into the example.

The Scenario

In this example, I am going to work through a hypothetical situation where I am the front-end developer for a coffee shop and I've been asked to create a report for an executive dashboard. The report needs to include Gross Revenue, Net Revenue and # of Orders for the current date for six groups of products (Breakfast Foods, Coffee, Coffee Beans, Tea, Tea Bags and Other) and five location groups which contain all the stores located in four states (California, Massachusetts, District of Columbia, New York and Others). The report needs to be in a table view and the person that requested this report also wants the ability to switch between the two columns for product groups and location groups. They also want a dashboard prompt for selecting from one or more groups for each column.

The Example

Let's start by tackling the custom groups. Since both groups are going to be created from the lowest level of detail for both products and locations, we need to bring in both Product Name and Shop Name columns and also our measures.

Note: For all of the examples in this blog series I am using OBIEE 12.2.1.2

use of presentation variable in obiee 11g

I can click on column properties > Edit Formula then click on the Bins tab to start creating my groups.

use of presentation variable in obiee 11g

In the Bins tab, I can click on Add Bin to start creating my first group.

use of presentation variable in obiee 11g

Once I click on Add Bin, I am presented with a New Filter window. The process of creating a new group (or bin) is exactly the same as creating a column filter. I can type the values individually, separated by ; or I can click on the search icon to add values manually. In this case, I am going to add them manually.

use of presentation variable in obiee 11g

Once in the Select Values window, I am going to select all of the products that belong in the first group (Breakfast Foods).

Note: In this scenario, the person has given me a list of all the products and stores that they want in each group

use of presentation variable in obiee 11g

Once I'm done adding all the items, clicking OK will take me to the Edit Bin Name window where I can give my new group (or Bin) a custom name.

use of presentation variable in obiee 11g

Since the person who requested the report probably wants the Others group to be last, I am going to add numerical values to each group. This will give me the flexibility to order columns any way that I choose. After I’m done creating all my Bins, there is a checkbox at the bottom of the Bins window where I can create a custom bin for all other values.

use of presentation variable in obiee 11g

Clicking OK will return me to the Criteria where I can view the formula that OBIEE generated for all of my selections.

use of presentation variable in obiee 11g

When using Bins, OBIEE generates a custom Case statement for us. At a high level, a Case statement takes a set of conditions and executes a corresponding statement. In other words, when the Product Name column has these values, put them all together an call them THIS .

If I go to Results, I can see the Bins I just created.

use of presentation variable in obiee 11g

Now I can return to the Criteria to create the groups for the stores. Upon completion, here is the formula for the Locations:

use of presentation variable in obiee 11g

And the result:

use of presentation variable in obiee 11g

Now I need to come up with a way to be able to switch between the Product and Location columns I just created. There are a couple of options. Since i'm using OBIEE 12c, I can save both the Products and Locations columns to the web catalog and simply create a column selector just like I would do for any of the columns within a subject area.

use of presentation variable in obiee 11g

There are two problems with this method. One is that the Save Column As feature is only available from OBIEE 11.1.1.9 forward so, if you are still on 11.1.1.7 or earlier, this method won't work. The second problem is that the request is not just for swapping the Product and Location columns with a prompt but also being able to select individual values for each column with a prompt. To avoid confusion, we probably want the prompt values for each column to change dynamically depending on which column is selected. To accomplish this I am going to use a second method which requires me to do the following:

Combine the case statements for both Products and Locations column formulas

Insert two additional case statements along with presentation variables to allow me to switch between the two.

Create a filter for the combined column with a presentation variable to allow me to use prompted values.

Create a variable type dashboard prompt to select between the Product and Locations independently.

Create a dashboard prompt that dynamically changes between the value selections for the Products and Locations.

I'm going to start with the first two steps since they require editing the same column formula.

I am going to create a new column and copy both my Products and Locations column formulas into the new column's edit formula window and, to make it easier to edit and insert the two additional case statements, I am going to put a blank line between them.

use of presentation variable in obiee 11g

Now I need to put in my two additional case statements with presentation variables so that I can switch between the two. The syntax and naming convention I am going to use is as follows:

CASE WHEN @{pv_select}['@']{'Products'} = 'Products' THEN [Products Case Statment]

CASE WHEN @{pv_select}['@']{'Products'} = 'Location' THEN [Locations Case Statment]

Let me take a moment to examine and explain the presentation variable I'm using.

The syntax for putting a presentation variable in a column formula, column heading or text object is as follows:

@{presentation_variable_name}[formatting]{default_value}

Note: I am going to use the presentation variable name (pv_select) in my variable prompt later in this example

The default value I have defined (Products) is an optional step that is primarily used for when I want to view my report without any values being passed into the presentation variable. The default value is used when no value has been passed into the presentation variable.

Notice that I have also included formatting between the presentation variable name and the default value (['@']). The reason for this is because the prompt values (which will be defined as Products and Locations in the variable prompt I will create) are a string (text) datatype and I have to explicitly define the format I need for the presentation variable value or I will get an error. You have to define formatting using single brackets [] and then encapsulate the @ character with the formatting you need applied to the presentation variable value. Think of the @ character as a sort of shorthand or an abbreviation for the presentation variable itself.

Note: I could enclose my presentation variable in single quotes to achieve the same results in this senario ('@{pv_select}{Products}' ).

So, to explain the entire statement another way:

CASE WHEN the value of the presentation variable coming from the prompt is equal to 'Products', THEN then use the CASE statment for the product groups

CASE WHEN the value of the presentation variable coming from the prompt is equal to 'Location', THEN then use the CASE statment for the location groups

My new column formula is as follows:

CASE WHEN @{pv_select}['@']{Products} = 'Products' THEN

CASE WHEN "Sales - Fact Sales"."Products"."Product Name" IN ('All Butter Croissant','Almond Croissant','Banana and Walnut Muffin','Blueberry Muffin','Caramel Shortbread','Chocolate Chip Muffin','Lemon Drizzle Muffin','Maple Pecan Danish') THEN '1. Breakfast Foods' WHEN "Sales - Fact Sales"."Products"."Product Name" IN ('Americano','Caramel Hot Cocoa','Classic Hot Cocoa','Dark Hot Cocoa','Expresso','Filter Coffee','Iced Caramel Latte','Iced Cocoa','Iced Latte','Iced Mocha','Latte','Macchiato','Mocha','Pain Au Chocolat','Vanilla Hot Cocoa','White Hot Cocoa') THEN '2. Coffee' WHEN "Sales - Fact Sales"."Products"."Product Name" IN ('Arabica Beans','Arabica Ground','Robustica Beans','Robustica Ground','GCBC Special Blend Instant') THEN '3. Coffee Beans' WHEN "Sales - Fact Sales"."Products"."Product Name" IN ('Chai Tea','Chamomile Tea','Earl Grey Tea','Fresh Mint Tea','Jasmine Tea','Spearmint Tea') THEN '4. Tea' WHEN "Sales - Fact Sales"."Products"."Product Name" IN ('Chamomile Tea Bags','Chai Tea Bags','Earl Grey Tea Bags','English Breakfast Tea Bags','Fresh Mint Tea Bags','Jasmine Tea Bags','Spearmint Tea Bags') THEN '5. Tea Bags' ELSE '6. Other' END

WHEN @{pv_select}['@']{'Products'} = 'Location' THEN

CASE WHEN "Shops"."Shop Name" IN ('SF1 - Fisherman''s Wharf', 'SF2 - South Beach', 'SJ1 - First Street Corridor', 'SV1 - Mountain View') THEN '1. California' WHEN "Shops"."Shop Name" IN ('BO1 - Financial District', 'BO2 - Atlantic Wharf', 'BO3 - Back Bay', 'CA2 - Harvard Square') THEN '2. Massachusetts' WHEN "Shops"."Shop Name" IN ('DC1 - Central Business District', 'DC2 - Dupont Circle') THEN '3. District of Columbia' WHEN "Shops"."Shop Name" IN ('NY1 - Times Square', 'NY2 - Fifth Avenue') THEN '4. New York' ELSE '5. Others' END ELSE 'Other' END*

I am also going to use the presentation variable in the column heading so that when I make my selection in the prompt, the column heading will reflect the selection as well.

use of presentation variable in obiee 11g

If I go back to my column formula and change the default value to be Location instead of Products, the column values will change to the ones defined in my Locations case statment.

use of presentation variable in obiee 11g

In order for the report to be filtered for individual values, I need to create a filter using a presentation variable. To do this I am going to create a filter for the column I used to define all of my groups and, instead of selecting a value, I am going to put in a new presentation variable which I will define later when I create the dashboard prompt for the values.

use of presentation variable in obiee 11g

I am going to name my new presentation variable pv_select_value .

use of presentation variable in obiee 11g

When a Presentation Variable is added to the filter, two new text boxes appear. The Variable Expr box is where you define the variable to be used and the (default) box is used to add a default value. Notice how I am not using the syntax @{presentation_variable_name} . When defining a presentation variable using the presentation variable option in a filter or in a prompt, you only have to define the name. Once I click ok, OBIEE will insert the proper syntax for me. The default value is optional but, when defining a Presentation Variable within a filter, you have to specify a default value in order to get any results within the analysis. If I run the report with just a presentation variable defined with no default value, I will get the error shown below:

use of presentation variable in obiee 11g

This is because, when the report is run, the query issued is trying to use the value of the presentation variable. Since there is no default value specified, it is trying to use the presentation variable name itself as a value. If I specify a default value or a list of default values, the report will use those values in the absence of a value or values in the presentation variable. Because I want all of the values to be shown initially on the dashboard, I am going to use the Convert this filter to SQL option and input all of the values for the product group manually for the list of default values.

use of presentation variable in obiee 11g

If I run the report with the default values specified, I get the results back for the product group.

use of presentation variable in obiee 11g

In order for the filter to work with the column prompt I will create later in this example, it requires the [formatting] syntax to be used ( @{pv_select_value}['@']{'1. Breakfast Foods', '2. Coffee', '3. Coffee Beans', '4. Tea', '5. Tea Bags', '6. Other'}) for example). This will encapsulate each value passed into the pv_select_value presentation variable with single quotes.

Now I need to add an additional filter on the same column using the same pv_select_value presentation variable. The reason for this is because I need to define each default value for the location group as well so that all of the values for location will be shown on the dashboard. To do this, I am going use the same process that I used for the product group filter.

use of presentation variable in obiee 11g

There is one additional step that I need to do in order to make the filter work for both products and locations. When you initially create report filters, OBIEE assumes that you want to use all filters together at the same time therefore it uses 'AND' for each filter created after the initial filter.

use of presentation variable in obiee 11g

If I run the report, I will get an error because the filter is being applied for both the products and location values. Because the case statment is defined for products and locations independently, I can not use all values in a filter at the same time.

use of presentation variable in obiee 11g

To fix this, I need to change the operator for the location filter from 'AND' to 'OR'. I can do this by simply clicking on the 'AND' icon.

use of presentation variable in obiee 11g

Now the report will run because only the first set of conditions for the product group filter is applied.

use of presentation variable in obiee 11g

Now I need to create my two dashboard prompts: One for the initial selection between my two case statements for Products and Locations and one for the values.

I start by creating a new dashboard prompt and create a new Variable Prompt.

use of presentation variable in obiee 11g

Because this is a variable prompt, I have to manually specify the values I want the user to be able to select from as well as define the presentation variable. Since I am creating the prompt for switching between the two case statements for Products and Locations, I am going to make the following selections and input the following values.

Prompt for: Presentation Variable > pv_select

User Input: Choice List

Choice List Values: Custom Values

Values: Products and Location

Default Selection: Specific Custom Value > Products

use of presentation variable in obiee 11g

As you can see, I have defined the variable that we used in the column formula for the case statements. By defining the two custom values (Products and Location), I can select between the two case statements at will and, as far as the user is concerned, it will be just like using a column prompt within a report. Also, the default value needs to be specified for reasons I will explain when creating the next prompt for the values.

Now I am going to create a column prompt for the values.

First, I need to create a new column prompt and put in the same column formula that I used earlier in my report. I can do that by clicking on the fx icon and pasting in the column formula.

use of presentation variable in obiee 11g

Essentially what I am doing is making the column values populate for the prompt by using the same case statement definitions and they will also change depending on the value selected in the prompt we created previously.

For the choice list of values, I can simply leave the default of All Column Values. Since the values will dynamically change depending on the initial prompt value in the variable prompt, it will only show values corresponding to each selection.

I do not need to define a default selection because I set the default values in the two filters I created in my report.

use of presentation variable in obiee 11g

Here are the results when placed on the dashboard.

use of presentation variable in obiee 11g

So that concludes part 1 of Demystification of Variables. Please feel free to ask questions or leave me a comment! In part 2, I am going to talk about using Repository, System and Presentation Variables to make reports dynamic for any series of time. Until next time.

Sign up for more like this.

Social Buttons

Data Warehouse | OBIEE | Informatica | Hadoop

Monday, May 12, 2014

Obiee 12c or obiee 11g : using multiple value for a presentation variable in criteria.

use of presentation variable in obiee 11g

323 comments

use of presentation variable in obiee 11g

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.

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

IEEE Final Year projects India Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Projects for CSE It gives you tips and rules that is progressively critical to consider while choosing any final year project point. Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms. Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai The Nodejs Training Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

Thank You, very nice tip.

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

Thanks for Information Flax 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..

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.

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

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

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

This comment has been removed by the author.

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

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

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

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

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

Great Article Java Online Course | Java EE Training Java Training Institutes in Chennai | java j2ee training institutes in chennai | Java Training in Chennai | J2EE Training in Chennai | Java Course in Chennai Java Interview Questions | Java Training Institutes | IT Technical Articles

use of presentation variable in obiee 11g

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

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

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

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

use of presentation variable in obiee 11g

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

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

Valuable information thanks for sharing OBIEE Online Training

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

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

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

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

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

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

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

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

Was a perfect solution for my issue Thank you so much

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

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

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

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

use of presentation variable in obiee 11g

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

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

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

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

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

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

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

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

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

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

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

Thank you so much for sharing. Keep updating your blog. It will very useful to the many users.. Best CCNP Training Institute in Chennai | Best CCNP Training in Velachery | Best CCNP Training Center in Pallikaranai

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

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

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

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

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

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

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

Really nice post. Thank you for sharing amazing information. BluePrism Training Institute in Chennai | BluePrism Training in Velachery

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

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

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

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

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

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

use of presentation variable in obiee 11g

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

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

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

Excellent article written in understandable way. thanks for sharing. join our,.. PCB Designing Training Institute in Chennai | PCB Training Center in Velachery | PCB Designing Courses in Perungudi

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

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

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

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

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

Your article is really an wonderful with useful content, thank you so much for sharing such an informative information. keep updating. MultiMedia Training Center in Chennai | MultiMedia Training Courses in Velachery | MultiMedia Training Institutes in OMR

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

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

Wonderful article..This is very informative blog. Glad to found your blog.Helps to gain knowledge about new concepts and techniques. Thanks for posting information in this blog.. Linux Certification Training Institute in Chennai | Linux Training Center in Velachery | Linux Courses in Medavakkam

This is useful post for me. I learn lot of new information from your post. keep sharing. thank you for share us.. Web Designing Training Institute in Chennai | Web Design Taining Center in Velachery | Web Designing Courses in Taramani

Your blog is really useful for me, and I gathered some information from this blog.Thanks a lot for sharing this amazing article.. CCNP Training Institute in Chennai | CCNP Training Center in Velachery | CCNP Training Courses in Pallikaranai | CCNP Training in Taramani | CCNP Courses in Medavakkam

Thanks for sharing this great article! That is very interesting I love reading and I am always searching for informative articles like this. MatLab Training Institute in Chennai | MatLab Training Center in Velachery | Matlab Courses in Adyar

It had taken much research as well as standard potentials to search for the data warehouse consulting companies , which can help in the process of data transformation excellently.

Awesome article. thanks for sharing this wonderful article with us.keep updating... Tally Training Institute in Chennai | Advanced Tally Courses in Guindy | Tally Training Center in Velachery

MBA Project Center in Chennai | MBA Project Center in Velachery | MBA HR Projects in Pallikaranai | MBA Finance Projects in Taramani

Thanks for Sharing the valuable information and thanks for sharing the wonderful article.. Embedded Training Institute in Chennai | Embedded Training Center in Velachery | Embedded Courses in Pallikaranai

Your post is very nice .this post is very useful to us… Selinium Course Training In Chennai | Selinium Course TrainingIn Velachery | Selinium Course TrainingIn Tambaram

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

Very interesting article.Helps to gain knowledge about lot of information. Thanks for posting information in this blog... Java Training Institute in Chennai | Java Training Center in Velachery | Advanced java Courses in Porur

You Posted a Nice post This post is very useful and Easy To Understand .. Cloud Computing Training in Chennai | Cloud Computing Training in Chennai | Cloud Computing Training in Chennai .

Thanks for sharing this valuable information to our vision, if anyone looking a Web Designing Training Institute in Chennai | Web Design Training Center in Velachery | WebDesign Courses in Taramani

Really superb post..Amazing content.Thanks for posting such a wonderful blog..keep updating.. Embedded Project Center in Chennai | Embedded Project Center in Velachery | Embedded Projects in Madipakkam | Embedded Projects Institute in Pallikaranai

This is really very impressive article with useful content,thanks for sharing your amazing post. MBA Project Center in Chennai | MBA Projects for Finance in Chennai | MBA Projects for HR in Chennai | MBA Projects for Marketing in Velachery | MBA Projects Center in Velachery

Great article Glad to find your blog,awesome blog with informative content.Thanks for sharing. Final Year Project Center in Chennai | Final Year Projects in Velachery | Final Projects for all domain Center in Velachery | Final Year projects for BE in Chennai

Really is very interesting and informative post, I saw your website and get more details..Nice work. Thanks for sharing your amazing article with us.. Image Processing Project Center in Chennai | Image Processing projects in Velachery | Image Processing Projects for BE in Velachery | Image Processing projects for ME in Velachery | Image processing projects in Chennai

Pretty blog, so many ideas in a single site, thanks for the informative article, keep updating more article. Android Project Center in Chennai | Android Project Center in Velachery | Android Projects for BE in Velachery | Android Projects for ME in Pallikaranai

Really Very happy to see this blog. thanks for sharing such a amazing blog... Mobile Computing Project Center in Chennai | Mobile Computing Projects in Velachery | Mobile Computing Projects in Medavakkam | Mobile Computing Projects in Pallikaranai

Nice and interesting blog to read..... keep updating Android Project Center in Chennai | Android Project Center in Velachery | Android Projects for BE in Velachery | Android Projects for ME in Chennai

I have read your blog. Good and more information useful for me, Thanks for sharing this information keep it up.... Dot Net Project Center in Chennai | Dot Net Project Center in Velachery | Dot Net Projects in OMR

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.

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

Very interesting blog which helps me to get the in depth knowledge about the technology, Thanks for sharing such a nice blog... IOT Project Center in Chennai | IOT Project Center in Velachery | IOT Projects for BE in Pallikaranai | IOT Projects for ME in Taramani

Really nice and good post. Thank you for sharing amazing information. PHP Project Center in Chennai | PHP Project Center in Velachery | PHP Projects in Velachery

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

Very interesting topic. Helps to gain knowledge about lot of information. Thanks for posting information in this blog. Cloud Computing Project Center in Chennai | Cloud Computing Project Center in Velachery | Cloud Computing Project Center in Medavakkam

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

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

Nice and interesting blog to read..... keep updating Final Year Project Center in Chennai | Final Year Project Center in Velachery | Final Year Projects in Guindy

Really Very happy to see this blog. thanks for sharing such a amazing blog... Best IOT Project Center in Chennai | IOT Project Center in Velachery | IOT Projects in Guindy

Thanks to share the useful information on your blog, Cloud Computing Project Center in Chennai | Cloud Computing Project Center in Velachery | Cloud Computing Projects in Tambaram

I really enjoyed this article. I need more information to learn so kindly update it. VLSI Project Center in Chennai | VLSI Projects Center in Velachery | VLSI Projects in Nanganallur

Nice and interesting article to read..... keep updating MBA Project Center in Chennai | MBA Project Center in Velachery | MBA Projects in Velachery | MBA Projects in Taramani

Awesome Blog with informative concept. Really I feel happy to see this useful blog, Thanks for sharing such a nice blog. Java Project Center in Chennai | Java Projects Center in Velachery | Java Projects in Perungudi

Really Very happy to see this blog. thanks for sharing such a amazing blog... Image Processing Project Center in Chennai | Image Processing Projects in Velachery | Image Processing Projects in Taramani

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

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

Thanks for giving nice information and informative blog...It's really an amazing post..keep updating.. MBA Project Center in Chennai | MBA Projects in Velachery | MBA Projects in Perungudi | MBA Finance Projects in Velachery | MBA HR Projects in Velachery | MBA Marketing Projects in Velachery

Very nice information to updating..Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging… Electrical Project Center in Chennai | Electrical projects in Velachery | Electrical Projects in St.thomas Mount

Really nice and good post. Thank you for sharing amazing information. PHP Project Center in Chennai | PHP Projects in Velachery | PHP Project Center in Nanganallur | PHP Projects in Guindy | PHP projects in Taramani

Very interesting, good job and thanks for sharing such blog. It is very interesting to read. Its pretty good and well noted. All your points are very useful. Cloud Computing Project Center in Chennai | Cloud Computing Projects in Velachery | Cloud Computing Projects in Chrompet

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

It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me... http://chennaitraining.in/sap-fico-training-in-chennai/ http://chennaitraining.in/sap-fscm-training-in-chennai/ http://chennaitraining.in/sap-grc-training-in-chennai/ http://chennaitraining.in/sap-hana-training-in-chennai/ http://chennaitraining.in/sap-hcm-training-in-chennai/ http://chennaitraining.in/sap-hr-training-in-chennai/ http://chennaitraining.in/sap-le-training-in-chennai/ http://chennaitraining.in/sap-mii-training-in-chennai/

It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me... http://chennaitraining.in/sap-mm-training-in-chennai/ http://chennaitraining.in/sap-mss-training-in-chennai/ http://chennaitraining.in/sap-pi-training-in-chennai/ http://chennaitraining.in/sap-pm-training-in-chennai/ http://chennaitraining.in/sap-pp-training-in-chennai/ http://chennaitraining.in/sap-ps-training-in-chennai/ http://chennaitraining.in/sap-qm-training-in-chennai/

Amazing article!!! Property Management company in chennai

Thanks for the great blogg!!! Salesforce Training | Online Course | Certification in chennai | Salesforce Training | Online Course | Certification in bangalore | Salesforce Training | Online Course | Certification in hyderabad | Salesforce Training | Online Course | Certification in pune

I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post.is article. Thanks for sharing nice article Salesforce Training | Online Course | Certification in chennai | Salesforce Training | Online Course | Certification in bangalore | Salesforce Training | Online Course | Certification in hyderabad | Salesforce Training | Online Course | Certification in pune

IEEE Cloud computing DOamin is a general term for anything that involves delivering hosted services over the Internet. cloud computing projects The cloud projects for cse is a metaphor for a global network of remote servers which operates as a single ecosystem, commonly associated with the Internet. IEEE FInal Year Networking Projects for CSE Domains Networking Projects cloud computing is the delivery of computing projects services—including servers, storage, databases, networking projects, software, analytics, and intelligence JavaScript Training in Chennai JavaScript Training in Chennai

Thanks for sharing this information, it helped me a lot in finding valuable resources for my career Java Training Institute in Chennai | Java Training Center in Velachery | java Training in Chennai

use of presentation variable in obiee 11g

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

Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging… No.1 MatLab Training Institute in Chennai | MatLab Training Center in Velachery | MatLab Training in Velachery

I have read your post, its very attractive and impressive. I like it your blog. C and C++ Training Institute in Chennai | C & C++ Training Center in Chennai | Online Training in Velachery

Great article Glad to find your blog. Thanks for sharing. PCB Design Training Institute in Chennai | PCB Training Center in Velachery | PCB Design Course in Velachery

use of presentation variable in obiee 11g

trung tâm tư vấn du học canada vnsava công ty tư vấn du học canada vnsava trung tâm tư vấn du học canada vnsava uy tín công ty tư vấn du học canada vnsava uy tín trung tâm tư vấn du học canada vnsava tại tphcm công ty tư vấn du học canada vnsava tại tphcm điều kiện du học canada vnsava chi phí du học canada vnsava #vnsava @vnsava

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

Awesome Blog with Smart Content, Thanks for sharing such a nice blog.. Embedded System Training in Chennai | Embedded Training Center in Velachery | Online Training Institute in Velachery

It is amazing and wonderful to visit your site.Thanks for sharing this information,this is helpful to me a lot... PCB Training Institute in Chennai | Online PCB Courses in Velachery | PCB Training in Velachery

I have read your blog. Your information is really useful for beginner. information provided here are unique and easy to understand.Thanks for this useful information....... PCB Design Training in Chennai | PCB Training Institute in Velachery | PCB Courses in Velachery | Online Training Institute in Velachery

Your Post is really wonderful and amazing content.Thanks for sharing such a useful blog and really good... Java Training Institute in Chennai | Java Training Center in Velachery | Online Training Institute in Velachery

This post is really nice and informative. The explanation given is really comprehensive and informative.. CCNA Training Institute in Chennai | CCNA Training Center in Velachery | CCNA Training Courses in Chennai | CCNA Training in Velachery | CCNA Online Training in Velachery

Thanks for giving nice information from your blog...It's really an amazing post... Tally Training Institute in Chennai | Tally Training Center in Velachery | Tally Training with GST Training in Velachery | Online Training Center in Velachery

Amazing Blog with Smart Content, Thanks for sharing such a nice blog.. Embedded Training Center in Chennai | Embedded System Training in Velachery | Embedded System Courses in Velachery

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

It is awesome and nice to visit your site. Thanks for sharing this information, this is helpful to me a lot... AWS Certification Training Center in Chennai | AWS Training Institute in Velachery | AWS Training in Velachery | AWS Online Training in Velachery

I have read your blog, its really very attractive and impressive. I like it your post. Thanks for sharing such a wonderful blog with us... PCB Training Institute in Chennai | PCB Training Center in Velachery | PCB Online Courses in Velachery | Online Training Center in Velachery

Very informative blog. Thanks a lot for sharing this wonderful blog. keep updating such a excellent post with us. Embedded System Training Center in Chennai | Embedded Training Institute in Velachery | Embedded Online Training in Velachery | Enbedded Courses in Velachery

I have read your blog. Your information is really useful for beginner. information provided here are unique and easy to understand. Thanks for this useful information. This is a great inspiring article. I am pretty much pleased with your good work. AWS Training Institute in Chennai | AWS Training Center in Velachery | AWS Certification Training in Velachery

Nice Information my sincere thanks for sharing this post Please Continue to share this kind of post Linux Training Institute in Chennai | Linux Training Center in Velachery | Online Linux Training in Velachery | Linux Courses in Velachery

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

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

Excellent article.It is really very helpful for us.keep sharing such a amazing post DOT NET Training Institute in Chennai | online DOT NET training | DOT NET Training Center in Velachery

Excellent article.It is really very helpful for us.keep sharing such a amazing post WEB DESIGNING Training Institute in Chennai | WEB DESIGNING Online Training | WEB DESIGNING Offline Training

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

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

Really wonderful blog.Thanks for sharing such excellent blog.It is very useful for us. A+,N+ Training Institute in Chennai | A+,N+ online Training Institute in Chennai | A+,N+ offline Training Institute in Chennai

Nice information .It is very useful for all.keeping sharing such excellent blogs.It is useful for us. JAVA Training Institute in Chennai | JAVA Online Training Institute in Chennai | JAVA Training Offline Institute in Chennai

Very informative blog.Thanks for sharing such a excellent blog.It is very useful for us.keep sharing such amazing blogs. SELENIUM Training institute in chennai | SELENIUM Online Training institute in chennai | SELENIUM Offline Training institute in chennai

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

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

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

Excellent blog thanks for sharing the valuable information..it becomes easy to read and easily understand the information. Useful article which was very helpful. also interesting and contains good information. to know about python training course , use the below link. Python Training in chennai Python Course in chennai

Nice Content delivery, thanks for sharing it is very informative. devops responsibilities seven habits of highly effective people mobile automation testing tools importance of web development ms excel interview questions and answers

This post is very simple to read and appreciate without leaving any details out. Great work! data science course in noida

The information is very useful.Thanks for sharing such excellent blog...... PMP certification Training in Velachery | PMP certification in Chennai

Liên hệ Aivivu, đặt vé máy bay tham khảo lịch bay singapore hà nội vé máy bay từ quy nhơn vào sài gòn vé bay huế hà nội vé máy bay huế đà lạt vé máy bay đi huế giá rẻ

Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating... CCNA Exam Center in Chennai and Velachery | AWS Training Center in Chennai & Velachery | Java Training center in velachery | Microsoft Azure Training Center in Chennai & Velachery | Best ISTQB Exam center in velachery |

Such a cute blog. Thank you for blogging. Keep adding more blogs. Very nicely presented. CCNA Exam Center in Chennai and Velachery | AWS Training Center in Chennai & Velachery | Java Training center in velachery | Microsoft Azure Training Center in Chennai & Velachery | Best ISTQB Exam center in velachery |

Thank you so much for sharing this worth able content with us. Keep blogging article like this. Python Training in Chennai and Velachery | AWS Training Center in Chennai & Velachery | Java Training center in velachery | Microsoft Azure Training Center in Chennai & Velachery | Best ISTQB Exam center in velachery |

“Excellent!” I have never seen blog like this. This post is really very interesting and effective. Kindly update your post soon. JAVATraining Institute in Velachery | JAVA Training Institute in Chennai

Thank you so much for sharing this worth able content with us. The concept taken here will be useful for my future programs and I will surely implement them in my study. Software Testing Training Center in Chennai and Velachery | CCNA Training Center in Chennai & Velachery | Java Training center in velachery | Microsoft Azure Training Center in Chennai & Velachery | Best ISTQB Exam center in velachery |

I have read your blog it's very interesting...Thank you for Sharing.. ISTQB Certification in Chennai and Velachery | Software Testing Training Center in Chennai and Velachery | CCNA Training Center in Chennai & Velachery | Java Training center in velachery | Microsoft Azure Training Center in Chennai & Velachery | Best ISTQB Exam center in velachery |

Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing. GRE Test Center in Chennai and Velachery | Software Testing Training Center in Chennai and Velachery | CCNA Training Center in Chennai & Velachery | Java Training center in velachery | Microsoft Azure Training Center in Chennai & Velachery | Best ISTQB Exam center in velachery |

Awesome blog. Your articles really impressed for me, because of all information so nice and unique... IELTS Test Center in Chennai and Velachery | Software Testing Training Center in Chennai and Velachery | CCNA Training Center in Chennai & Velachery | Java Training center in velachery | Microsoft Azure Training Center in Chennai & Velachery | Best ISTQB Exam center in velachery |

Nice blog. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details. Java Training center in velachery | Microsoft Azure Training Center in Chennai & Velachery | Best ISTQB Exam center in velachery | Dot Net Trainig in Chennai and Velachery | Python Training Center in Chennai and Velachery | CCNA Training Center in Chennai & Velachery |

Nice post. It was really effective. Thank you for sharing. Python Training Center in Chennai and Velachery | CCNA Training Center in Chennai & Velachery Java Training center in velachery | Microsoft Azure Training Center in Chennai & Velachery | Best ISTQB Exam center in velachery | Dot Net Trainig in Chennai and Velachery |

Nice blog. Thank you for sharing. The information you shared is very effective for learners I have got some important suggestions from it… Web Designing and Development Training in velachery | Microsoft Azure Training Center in Chennai & Velachery | Best ISTQB Exam center in velachery | Dot Net Trainig in Chennai and Velachery | Python Training Center in Chennai and Velachery | CCNA Training Center in Chennai & Velachery Java Training center in velachery |

Really I Enjoy this Blog…Very Nice Post…Thanks…. Dot Net Trainig in Chennai and Velachery | Python Training Center in Chennai and Velachery | CCNA Training Center in Chennai & Velachery Java Training center in velachery | Web Designing and Development Training in velachery | Microsoft Azure Training Center in Chennai & Velachery | Best ISTQB Exam center in velachery |

It is a one of the great Explanation, which is very essential for me as well. Web Designing and Development Training in velachery | Dot Net Trainig in Chennai and Velachery | Python Training Center in Chennai and Velachery | CCNA Training Center in Chennai & Velachery Java Training center in velachery | Microsoft Azure Training Center in Chennai & Velachery | Best ISTQB Exam center in velachery |

Great article, your blog was really unique... thanks for sharing… Selenium Training Center in Velachery | Tally Training center in velachery | Software Testing Training Center in Velachery | Web Designing and Development Training in velachery | Dot Net Trainig in Velachery | Python Training Center in Velachery | Java Training center in velachery |

Wonderful Article. Thank you for updating such an informative content. Python Training Center in Velachery | Java Training center in velachery | Selenium Training Center in Velachery | Tally Training center in velachery | Software Testing Training Center in Velachery | Web Designing and Development Training in velachery | Dot Net Trainig in Velachery |

Nice Post. Thanks for sharing. Keep on updating. Software Testing Training Center in Velachery | Web Designing and Development Training in velachery | Dot Net Trainig in Velachery | Python Training Center in Velachery | Java Training center in velachery | Selenium Training Center in Velachery | Tally Training center in velachery |

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

This blog is really useful and it is very interesting thanks for sharing, it is really good and exclusive. Tally Training center in velachery | Software Testing Training Center in Velachery | Web Designing and Development Training in velachery | Dot Net Trainig in Velachery | Python Training Center in Velachery | Java Training center in velachery | Selenium Training Center in Velachery |

Thanks for sharing such a wonderful blog here... Dot Net Trainig in Velachery | Python Training Center in Velachery | Java Training center in velachery | Selenium Training Center in Velachery | Tally Training center in velachery | Software Testing Training Center in Velachery | Web Designing and Development Training in velachery |

Impressive blog with lovely information. Really very useful article for us thanks for sharing such a wonderful blog... Python Training Center in Velachery | Java Training center in velachery | Selenium Training Center in Velachery | Tally Training center in velachery | Software Testing Training Center in Velachery | Web Designing and Development Training in velachery | Dot Net Trainig in Velachery |

Nice to read this article.... Thanks for sharing this information..... CCNA Training Center in Chennai | CCNP Training center in Chennai | Selenium Training Center in Chennai | Tally Training center in Chennai | AWS Training Center in Chennai | Web Designing and Development Training in Chennai | Dot Net Trainig in Chennai |

Excellent information with unique content and it is very useful to know about the information based on blogs... Web Designing and Development Training in Chennai | Dot Net Trainig in Chennai | CCNA Training Center in Chennai | CCNP Training center in Chennai | Selenium Training Center in Chennai | Tally Training center in Chennai | Softwa Testing Training Center in Chennai |

Awesome post. Really you are shared very informative concept... Thank you for sharing. Keep on updating... JAVA Training in Chennai | Summer Courses Training in Chennai | Software Testing Training in Chennai | ISTQB Training in Chennai | Selenium Automation Training in Chennai |

Nice and informative article. Thanks for sharing such nice article, keep on updating. Selenium Training in Chennai | ISTQB Training in Chennai | Summer Courses Training in Chennai | Software Testing Training in Chennai | JAVA Training in Chennai |

Interesting post. This is really helpful for me. I like it. Thanks for sharing. IELTS Test Center in Chennai | JAVA Training in Chennai | Selenium Training in Chennai | Summer Courses Training in Chennai | Software Testing Training in Chennai |

The Content you have post on this blog Guided me to get into the Advanced level and had lot of information in it… Web Designing Training Center in Velachery | Summer Courses Training in Velachery | Software Testing Training in Velachery | JAVA Training in Velachery | Selenium Training in Velachery |

Very Excellent and awesome Blog you are posted each and every Points are unique. Thanks for sharing such a nice Blog, keep on updating more Summer Courses Training in Tharamani | JAVA Training in Tharamani | Web Designing Training Center in Tharamani | Software Testing Training in Tharamani | Selenium Training in Tharamani |

Awesome information...It was learned more information about your blog. Thanks for sharing, keep updating. Web Designing Training Center in Velachery | Software Testing Training in Velachery | Selenium Training in Velachery | Summer Courses Training in Velachery | JAVA Training in Velachery |

Wow such a nice blog, very usefull information. Thanks for sharing. JAVA Training in Velachery | Web Designing Training Center in Velachery | Tally Training in Velachery | Selenium Training in Velachery | Summer Courses Training in Velachery |

The information you have here is really useful . It is truly supportive for us and I have accumulated some essential data from this blog. Web Designing Training Center in Chennai | Tally Training in Chennai | Selenium Training in Chennai | Summer Courses Training in Chennai | JAVA Training in Chennai |

I am getting lots of information from your site. Keep posting . Thank you... Hardware and Networking Training in Chennai | Web Designing Training Center in Chennai | Tally Training in Chennai | Summer Courses Training in Chennai | AWS Training in Chennai |

Thank you for sharing your article. Great efforts put it to find the list of articles which is very useful to know, Definitely will share the same to other forums. Amazon Web Services Training in Chennai

Excellent Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging… Python Training in Chennai | Web Designing Training Center in Chennai | Tally Training in Chennai | AWS Training in Chennai | Hardware and Networking Training in Chennai |

Total Visits

Feature video.

' border=

' border=

' border=

Join the Club

BI Solutions By Shankha Bhattacharya

Tag archives: obiee presentation variable, workaround – obiee 11g – constrained prompts and prompt default value.

Here is a simple workaround to an important functionality.

Problem description can be found here – https://myobieespace.wordpress.com/2015/02/11/obiee-11g-constrained-prompts-and-prompt-default-value/

One liner solution to this problem is to split the prompt and use presentation variable to pass values to mimic the constrained functionality.

For example if we have to create a constrained Year and Month Prompt with default value for Month Prompt then we follow the following steps to achieve this –

1) Create two different prompts one for Year and another for Month.

2) From the Year prompt populate a Presentation Variable called YEAR.

3) Use this presentation variable YEAR in the default SQL section in the Month Prompt to drive the default value of the Month Prompt. Use this presentation variable YEAR in the Prompt choice list section also to drive the choice list in the Month prompt. Following pictures depicts the same –

Year Prompt to populate the YEAR presentation Variable –

Set Presentation Variable in OBIEE 11g

Set Presentation Variable in OBIEE 11g

Use the Presentation variable YEAR in the Month Prompt –

OBIEE 11g prompt Default Selection and Choice list

Default selection SQL in Month prompt and Choice list

The ORDER BY clause in the default selection ensures that the first month is defaulted in the month prompt for a selected value in the Year prompt. Hope this helps….

Posted by Shankha on February 25, 2015 in Quick Tips , Webcat Essentials

Tags: Cascading prompts , choice list in prompt , Constrained Prompts in OBIEE 11g , Default selection in OBIEE 11g Prompts , OBIEE Presentation Variable , populate choice list in obiee 11g

OBIEE 11g – Constrained Prompts and Prompt Default Value

Lets begin with an example. For a Time Period Dimension the hierarchy will look like Year-> Month -> Day. Suppose this has been configured in the repository. Now the requirement is to create a Year and Month Prompt where Month is constrained by a Single Select Year Prompt. And by default the value selected in the Month prompt should be the first month of the year i.e. for Year = 2002 the Month prompt should display 01/2002 . This is fine when the dashboard is loaded for the first time. But when the user changes the Year prompt to 2005 say , the Month prompt should automatically select 01/2005. Hope the requirement is clear. This particular requirement was straight forward and looked simple till the time I really started to build this.

Constrained Prompt

Highlighted areas show how to constrain Month Prompt by Year Prompt. The Default Sql Orders the Month and shows the first value as shown above. But what happens when the user selects some other value in the Year Prompt…..BOOM the default value in the Month prompt becomes NULL.

Change Default

Doing some query analysis shows that the Query written in the Default section of the Month prompt is fired only once while the prompt is loaded for the first time. The Default value is not populated when the Year is changed in the run time by a User.

After some research I found there is a already a Enhancement Request (17400866) in the Oracle site for this. This has been identified as a BUG (but I didn’t find this in any known bugs). This is what oracle has to say –

https://community.oracle.com/message/12095168#12095168

Now that Oracle was unable to provide a solution I tried to find a workaround for the same and dramatically found one. My next post will document the same.

Here is a simple solution for this problem –

https://myobieespace.wordpress.com/2015/02/25/workaround-obiee-11g-constrained-prompts-and-prompt-default-value/

Posted by Shankha on February 11, 2015 in Webcat Essentials

Tags: Cascading prompts , choice list in prompt , Constrained Prompts in OBIEE 11g , Default SQL Query in Prompts , Default value , Default value in Constrained prompts , OBIEE 11g Prompts , OBIEE Presentation Variable , populate choice list in obiee 11g , populate default value in OBIEE 11g prompt , Presentation variable , Prompt Constraining

Using Presentation Variable in OBIEE Dashboards

How can we set a Presentation Variable without displaying the prompt associated with it in a dashboard?

We all know that a Presentation variable is set through a Prompt. But if we want to use a presentation variable in a dashboard or in the reports without displaying the associated prompt we have to define the path of the prompt in the following place so that the Presentation variable is populated correctly when the dashboard is loaded –

Go to the Edit Dashboard from the dashboard where we want to use the Presentation variable –

Edit Dashboard

Go to Dashboard Properties – > Edit Dashboard –

Edit Dashboard

select the filter or prompt that you want to include in the dashboard. This prompt we will be putting here will  populate the presentation variable to be used in the dashboard reports.

dashboard_filter

When this dashboard page will be loaded then the prompts defined in this sections will be fired and the corresponding Presentation Variables will be populated. We can define multiple prompts in this section and populate multiple Presentation variables together.

Posted by Shankha on January 16, 2015 in Webcat Essentials

Tags: Dashboard , OBIEE 11g , OBIEE Presentation Variable , Presentation variable

Shankha Bhattacharya

' src=

Plainsboro, NJ

Recent Posts

Blog at WordPress.com.

Entries (RSS) and Comments (RSS)

' src=

IMAGES

  1. OBIEE

    use of presentation variable in obiee 11g

  2. Default selection in OBIEE 11g Prompts

    use of presentation variable in obiee 11g

  3. OBIEE

    use of presentation variable in obiee 11g

  4. OBIEE 10G/11G

    use of presentation variable in obiee 11g

  5. OBIEE 11g: Multiple Values in Presentation Variables

    use of presentation variable in obiee 11g

  6. OBIEE

    use of presentation variable in obiee 11g

VIDEO

  1. 10 Mysterious Paran0rmal Videos Worldwide

  2. Core Java || "IO Streams "|| Part

  3. Oracle Data Integrator 11g Introduction Part-I.flv

  4. OBIEE 12c Developer Course : Data Modelling Introduction

  5. OBIEE training materials, OBIEE 11g training

  6. OBIEE 11g Tutorials for Beginners

COMMENTS

  1. How to Use Presentation Variable in OBIEE

    Model, Build and Deploy complex repositories. create analyses, dashboards, KPIs and scorecards. understand and work security in OBIEE 11g.

  2. Lesson 7: Variables and Dashboard Prompts

    values of Presentation variables may be used as filtering conditions for any analyses on the ... This is the default behavior in OBIEE 11g.

  3. OBIEE 10G/11G

    Dashboard prompt · Select in the Set Variable Column, the value “Presentation variable” · Enter a name for your presentation variable.

  4. Presentation Variable in OBIEE

    A Presentation Variable is a variable which can be created as part of creation of dashboard prompts. Dashboard prompts must be either Column

  5. OBIEE 11g : Presentation Variable Passed in the Action Link is

    When you move to other analysis by the action link, it is ok to have the correct Presentation Variables. But when pressing the paging button

  6. OBIEE 11g

    Goal. This document is created to describe how to refer a presentation variable that can have multiple values. Solution. Sign In

  7. Using Presentation Variable with All Column Values or No Default

    Using Presentation Variable with All Column Values or No Default Value Option in OBIEE 11G ... A presentation variable is passed to a report in dashboard to

  8. Real World OBIEE: Demystification of Variables Pt. 1

    These are one of the most powerful features in Answers. They are also one of the things that trip people up the most. Think of presentation

  9. OBIEE 12c or OBIEE 11g : Using multiple value for a presentation

    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

  10. OBIEE Presentation Variable

    Using Presentation Variable in OBIEE Dashboards · Edit Dashboard. Go to Dashboard Properties – > Edit Dashboard – · Edit Dashboard. select the