TIMESTAMPS and Presentation Variables

TIMESTAMPS and Presentation Variables can be some of the most useful tools a report creator can use to invent robust, repeatable reports while maximizing user flexibility.  I intend to transform you into an expert with these functions and by the end of this page you will certainly be able to impress your peers and managers, you may even impress Angus MacGyver.  In this example we will create a report that displays a year over year analysis for any rolling number of periods, by week or month, from any date in time, all determined by the user.  This entire document will only use values from a date and revenue field.

Final Month DS

The TIMESTAMP is an invaluable function that allows a user to define report limits based on a moving target. If the goal of your report is to display Month-to-Date, Year-to-Date, rolling month or truly any non-static period in time, the TIMESTAMP function will allow you to get there.  Often users want to know what a report looked like at some previous point in time, to provide that level of flexibility TIMESTAMPS can be used in conjunction with Presentation Variables.

To create robust TIMESTAMP functions you will first need to understand how the TIMESTAMP works. Take the following example:

Filter Day -7 DS

Here we are saying we want to include all dates greater than or equal to 7 days ago, or from the current date.

  • The first argument, SQL_TSI_DAY, defines the T ime S tamp I nterval (TSI) . This means that we will be working with days.
  • The second argument determines how many of that interval we will be moving, in this case -7 days.
  • The third argument defines the starting point in time, in this example, the current date.

So in the end we have created a functional filter making Date >= 1 week ago, using a TIMESTAMP that subtracts 7 days from today.

Results -7 Days DS

Note: it is always a good practice to include a second filter giving an upper limit like "Time"."Date" < CURRENT_DATE. Depending on the data that you are working with you might bring in items you don’t want or put unnecessary strain on the system.

We will now start to build this basic filter into something much more robust and flexible.

To start, when we subtracted 7 days in the filter above, let’s imagine that the goal of the filter was to always include dates >= the first of the month. In this scenario, we can use the DAYOFMONTH() function. This function will return the calendar day of any date. This is useful because we can subtract this amount to give us the first of the month from any date by simply subtracting it from that date and adding 1.

Our new filter would look like this:

DayofMonth DS

For example if today is December 18 th , DAYOFMONTH(CURRENT_DATE) would equal 18. Thus, we would subtract 18 days from CURRENT_DATE, which is December 18 th , and add 1, giving us December 1 st .

MTD Dates DS

(For a list of other similar functions like DAYOFYEAR, WEEKOFYEAR etc. click here .)

To make this even better, instead of using CURRENT_DATE you could use a prompted value with the use of a Presentation Variable (for more on Presentation Variables, click here ). If we call this presentation variable pDate, for prompted date, our filter now looks like this:

pDate DS

A best practice is to use default values with your presentation variables so you can run the queries you are working on from within your analysis. To add a default value all you do is add the value within braces at the end of your variable. We will use CURRENT_DATE as our default, @{pDate}{CURRENT_DATE}.  Will will refer to this filter later as Filter 1.

{Filter 1}:

pDateCurrentDate DS

As you can see, the filter is starting to take shape. Now lets say we are going to always be looking at a date range of the most recent completed 6 months. All we would need to do is create a nested TIMESTAMP function. To do this, we will “wrap” our current TIMESTAMP with another that will subtract 6 months. It will look like this:

Month -6 DS

Now we have a filter that is greater than or equal to the first day of the month of any given date (default of today) 6 months ago.

Month -6 Result DS

To take this one step further, you can even allow the users to determine the amount of months to include in this analysis by making the value of 6 a presentation variable, we will call it “n” with a default of 6, @{n}{6}.  We will refer to the following filter as Filter 2:

{Filter 2}:

n DS

For more on how to create a prompt with a range of values by altering a current column, like we want to do to allow users to select a value for n, click here .

Our TIMESTAMP function is now fairly robust and will give us any date greater than or equal to the first day of the month from n months ago from any given date. Now we will see what we just created in action by creating date ranges to allow for a Year over Year analysis for any number of months.

Consider the following filter set:

Robust1 DS

This appears to be pretty intimidating but if we break it into parts we can start to understand its purpose.

Notice we are using the exact same filters from before (Filter 1 and Filter 2).  What we have done here is filtered on two time periods, separated by the OR statement.

The first date range defines the period as being the most recent complete n months from any given prompted date value, using a presentation variable with a default of today, which we created above.

The second time period, after the OR statement, is the exact same as the first only it has been wrapped in another TIMESTAMP function subtracting 1 year, giving you the exact same time frame for the year prior.

YoY Result DS

This allows us to create a report that can run a year over year analysis for a rolling n month time frame determined by the user.

A note on nested TIMESTAMPS:

You will always want to create nested TIMESTAMPS with the smallest interval first. Due to syntax, this will always be the furthest to the right. Then you will wrap intervals as necessary. In this case our smallest increment is day, wrapped by month, wrapped by year.

Now we will start with some more advanced tricks:

  • Instead of using CURRENT_DATE as your default value, use yesterday since most data are only as current as yesterday.  If you use real time or near real time reporting, using CURRENT_DATE may be how you want to proceed. Using yesterday will be valuable especially when pulling reports on the first day of the month or year, you generally want the entire previous time period rather than the empty beginning of a new one.  So, to implement, wherever you have @{pDate}{CURRENT_DATE} replace it with @{pDate}{TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE)}
  • Presentation Variables can also be used to determine if you want to display year over year values by month or by week by inserting a variable into your SQL_TSI_MONTH and DAYOFMONTH statements.  Changing MONTH to a presentation variable, SQL_TSI_@{INT}{MONTH} and DAYOF@{INT}{MONTH}, where INT is the name of our variable.  This will require you to create a dummy variable in your prompt to allow users to select either MONTH or WEEK.  You can try something like this: CASE MOD(DAY("Time"."Date"),2) WHEN 0 'WEEK' WHEN 1 THEN 'MONTH' END

INT DS

In order for our interaction between Month and Week to run smoothly we have to make one more consideration.  If we are to take the date December 1st, 2014 and subtract one year we get December 1st, 2013, however, if we take the first day of this week, Sunday December 14, 2014 and subtract one year we get Saturday December 14, 2014.  In our analysis this will cause an extra partial week to show up for prior years.  To get around this we will add a case statement determining if '@{INT}{MONTH}' = 'Week' THEN subtract 52 weeks from the first of the week ELSE subtract 1 year from the first of the month.

Our final filter set will look like this:

Final Filter DS

With the use of these filters and some creative dashboarding you can end up with a report that easily allows you to view a year over year analysis from any date in time for any number of periods either by month or by week.

Final Month Chart DS

That really got out of hand in a hurry! Surely, this will impress someone at your work, or even Angus MacGyver, if for nothing less than he or she won’t understand it, but hopefully, now you do!

Also, a colleague of mine Spencer McGhin just wrote a similar article on year over year analyses using a different approach. Feel free to review and consider your options.

Calendar Date/Time Functions

These are functions you can use within OBIEE and within TIMESTAMPS to extract the information you need.

  • Current_Date
  • Current_Time
  • Current_TimeStamp
  • Day_Of_Quarter
  • Month_Of_Quarter
  • Quarter_Of_Year
  • TimestampAdd
  • TimestampDiff
  • Week_Of_Quarter
  • Week_Of_Year

Back to section

Presentation Variables

The only way you can create variables within the presentation side of OBIEE is with the use of presentation variables. They can only be defined by a report prompt. Any value selected by the prompt will then be sent to any references of that filter throughout the dashboard page.

In the prompt:

Pres Var DS

From the “Set a variable” dropdown, select “Presentation Variable”. In the textbox below the dropdown, name your variable (named “n” above).

When calling this variable in your report, use the syntax @{n}{default}

If your variable is a string make sure to surround the variable in single quotes: ‘@{CustomerName]{default}’

Also, when using your variable in your report, it is good practice to assign a default value so that you can work with your report before publishing it to a dashboard. For variable n, if we want a default of 6 it would look like this @{n}{6}

Presentation variables can be called in filters, formulas and even text boxes.

Dummy Column Prompt

For situations where you would like users to select a numerical value for a presentation variable, like we do with @{n}{6} above, you can convert something like a date field into values up to 365 by using the function DAYOFYEAR("Time"."Date").

As you can see we are returning the SQL Choice List Values of DAYOFYEAR("Time"."Date") <= 52.  Make sure to include an ORDER BY statement to ensure your values are well sorted.

Dummy Script DS

Back to Section

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 presentation variable in filter obiee

148 comments

use presentation variable in filter obiee

Thank You, very nice tip.

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

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.

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

use presentation variable in filter obiee

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

use presentation variable in filter obiee

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

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

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

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 presentation variable in filter obiee

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

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

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

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

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

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

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

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

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

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

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

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 .

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

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

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

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 article to read..... keep updating MBA Project Center in Chennai | MBA Project Center in Velachery | MBA Projects in Velachery | MBA 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

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

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

use presentation variable in filter obiee

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

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 presentation variable in filter obiee

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

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

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

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

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

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

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 |

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 |

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 |

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 |

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

Awesome article and Unique Words. Thanks for sharing such nice article……… IELTS Exams in Velachery | IELTS Exams in Chennai | IELTS Exams in Tharamani | IELTS Exams in Perungudi | IELTS Exams in Thambaram

This Article is really helpful for me. I like it. Thanks for sharing. Hardware and Networking Training in Chennai | AWS Training in Chennai | Web Designing Training Center in Chennai | Python Training in Chennai | Tally Training in Chennai | Dot Net Training in Chennai |

The Blog Content was Awesome !Thanks for sharing this unique blog keep posting more….. Python Training in Chennai | Tally Training in Chennai | Dot Net Training in Chennai | Hardware and Networking Training in Chennai | AWS Training in Chennai | Web Designing Training Center in Chennai |

Wonderful information and really very much useful. Thanks for sharing and keep updating More like this……... AWS Training in Chennai | Python Training in Chennai | Tally Training in Chennai | Dot Net Training in Chennai | Hardware and Networking Training in Chennai | Web Designing Training Center in Chennai

excellent blog.... PMP Exam Center in Chennai | PMP Exam Center in Velachery | PMP Exam Center in medavakkam

Wow such an Amazing Blog!we need more info like this so we can learn something new. PCB Training Institute In Chennai. | PCB Training Institute In velachery. | PCB Training Institute In medavakkam | PCBTraining Institute Pallikaranai. | PCB Training Institute In Tharamani. | PCB Training Institute In Thiruvanmiyur. | PCB Training Institute In perungudi. | PCB Training Institute In Thambaram. .

Excellent post.. Thank you so much for sharing your nice blog with useful content with us.... ITIL Exam Center in Chennai | ITIL Exams in Velachery | ITIL Exam Center in Velachery | ITIL Exams in Perungudi | Online Certification in Chennai

Valuable information shared with us . Thanks for your excellent information. AWS Training Institute in Chennai | AWS online Training Institute in Velachery | AWS offline Training Institute in velachery | AWS Training Institute in Tharamani | AWS Training Institute in Medavakkam

Excellent blog with valuable information.. MCSA Training Institute in Chennai | MCSA Training Institute in Velachery | MCSA Training Institute in Medavakkam | MCSA Training Institute in Tharamani

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

unique content and it is very useful to know about the information based on blogs... Python Training in Tharamani | CCNA Training in chennai | Dot Net Training in thambaram | Hardware and Networking Training in perungudi | Web Designing Training Center in guindy AWS Training in Velachery |

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

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

Really very useful article for us thanks for sharing such a wonderful blog... Data Science Training in Chennai | Data Science Training in Velachery | Data Science Training in Tharamani | Data Science Training in Perungudi | Data Science Training in Thambaram

Good Niche ! Thanks for sharing such a wonderful blog here... AWS Training in Velachery | Hardware and Networking Training in Velachery | Web Designing Training Center in Velachery JAVA Training in Velachery | CCNA Training in Velachery | CCNP Training in Velachery | Python Training in Velachery |

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

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

Excellent information. Thanks for sharing such a great blog with us. Linux Training Institute in Chennai | Linux Training Institute in Tharamani | Linux Training Institute in Medavakkam | Linux Training Institute in Velachery

Awesome article you have shared, thank you so much for posting such a useful information.. PCB Design Training Institute in Chennai | PCB Designing Training Center in Velachery | Online PCB Design Courses in Chennai | PCB Courses in Velachery

Wonderful Article. Thank you for updating such an informative content. Linux Training in chennai | Dot Net Training in chennai | AWS Training in chennai | Certified Ethical Hacking Training in Chennai | Hardware and Networking Training in chennai | Python Training in chennai | Web Designing Training Center in chennai

Thanks for giving nice information from your blog...It's really an amazing post... ISTQB Certification in Chennai | OISTQB Exam Center in Velachery | ISTQB Certification in Velachery | Online Certification in Chennai

“Superb!” Very Creative.... You have done really great job. It’s really useful to everyone .Thanks for share MCSA Training Institute in Velachery | MCSA Training Institute in Chennai | MCSA Training Institute in Tambaram | MCSA Training Institute in Taramani |

I have read your blog, it's really very attractive and impressive. I like your content. Thanks for sharing such amazing information with us... Software Testing Training Institute In Chennai. | Software Testing Android Training Institute In velachery. | Software Testing Training Institute In medavakkam | Software TestingTraining Institute Pallikaranai. | Software Testing Training Institute In Tharamani. | Software Testing Training Institute In Thiruvanmiyur. | Software Testing Training Institute In perungudi. | Software Testing Training Institute In Thambaram. .

The Information that is shared is very nice and interesting. Linux Training Institute in Chennai | Linux Training Institute in Tharamani | Linux Training Institute in Medavakkam | Linux Training Institute in Velachery

I have read your blog, its really very attractive and impressive. I like your content. Thanks for sharing such an amazing information with us... CCNA Training Institute In Chennai. | CCNA Training Institute In velachery. | CCNA Training Institute In medavakkam | CCNA Training Institute Pallikaranai. | CCNATraining Institute In Tharamani. | CCNA Training Institute In Thiruvanmiyur. | CCNA Training Institute In perungudi. | CCNA Training Institute In Thambaram. .

Nice post. It was really effective. Thank you for sharing. AWS Training in Chennai & velachery | Certified Ethical Hacking Training in Chennai & velachery | Linux Training in Chennai & velachery | Hardware and Networking Training in Chennai & velachery | JAVA Training in Chennai & velachery | Python Training in Chennai & velachery | Dot Net Training in Chennai & velachery | Web Designing Training Center in Chennai & velachery |

Amazing Information my sincere thanks for sharing this post Please Continue to share this kind of blog.. Final Year Project Center in Chennai | Final Year Projects in Velachery | Final Year IEEE Projects in Velachery | Online Project Center in Chennai | BE Projects in Chennai | ME Projects in Velachery

Excellent blog with excellent content... PCB Design Training in Chennai | PCB Design Training in perungudi | PCB Design Training in tharamani | PCB Design Training in velachery

Excellent content with useful information. I am looking forward for your future posts. Keep up the Good work. CCNA & CCNP Training Institute in Velachery | CCNA & CCNP Training Institute in Chennai | CCNA & CCNP Training Institute in Tambaram |

very interesting article... Embedded system Training Institute in Chennai | Embedded system Training Institute in Chennai | Embedded system Training Institute in Medavakkam | Embedded system Training Institute in perungudi | Embedded system Training Institute 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. AWS Training in Chennai & velachery | Certified Ethical Hacking Training in Chennai & velachery | Linux Training in Chennai & velachery | Hardware and Networking Training in Chennai & velachery | Dot Net Training in Chennai & velachery | Web Designing Training Center in Chennai & velachery | JAVA Training in Chennai & velachery | Python Training in Chennai & velachery |

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.

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

Really nice blog.. Thanks for sharing.. GMAT Test Center in Chennai | GMAT Test Center in velachery

Nice Blog. Thank you for Sharing.. Python Training Institute in Chennai | python Training in Velachery

Interesting post. This is really helpful for me. I like it. Thanks for sharing. JAVA Training in Chennai | Python Training in Chennai | AWS Training in Chennai | Certified Ethical Hacking Training in Chennai | Linux Training in Chennai | Hardware and Networking Training in Chennai | Dot Net Training in Chennai | Web Designing Training Center in Chennai |

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 |

Impressive blog with lovely information. Really very useful article for us thanks for sharing such a wonderful blog... Advanced & Core JAVA Training in Chennai | Python Training in Chennai | AWS Training in Chennai | Certified Ethical Hacking Training in Velachery | Linux Training in Chennai | Hardware and Networking Training in Chennai | Dot Net Training in Chennai | Web Designing Training Center in Chennai |

Nice post. It was really effective. Thank you for sharing. Certified Ethical Hacking Training in Velachery | Linux Training in Velachery | Advanced & Core JAVA Training in Velachery | Python Training in Velachery | Hardware and Networking Training in Velachery | Dot Net Training in Velachery | Web Designing Training Center in Velachery | AWS Training in Velachery |

Thank you so much for sharing this worth able content with us. The Niche taken here will be useful for my future programs and I will surely implement them in my study. Hardware and Networking Training in Chennai and Velachery | Dot Net Training in Chennai and Velachery | Web Designing Training Center in Chennai and Velachery | Certified Ethical Hacking Training in Chennai and Velachery | Linux Training in Chennai and Velachery | Advanced & Core JAVA Training in Chennai and Velachery | Python Training in Chennai and Velachery |

Thank you so much for sharing this worth able content with us. Keep blogging article like this. Advanced & Core JAVA Training in Velachery | Python Training in Velachery | Hardware and Networking Training in Velachery | Dot Net Training in Velachery | Web Designing Training Center in Velachery | Certified Ethical Hacking Training in Velachery | Linux Training in Velachery | AWS Training in Velachery |

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

Interesting post. This is really helpful for me as a career Growth. Thanks for sharing…… Certified Ethical Hacking Training in Guindy | Linux Training in Guindy | AWS Training in Guindy | Advanced & Core JAVA Training in Guindy | Python Training in Guindy | Hardware and Networking Training in Guindy | Dot Net Training in Guindy | Web Designing Training Center in Guindy |

Wow!!... Superb blog with wonderful information.. PCB Design Training Institute in Chennai | PCB Design Training Center in Velachery

very excellent blog . . . AWS Training Institute in Chennai | CCNA Training Institute in Chennai | Linux Training Institute in Chennai | CCNA Training Institute in Velachery

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

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.

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 about SEO Questions and Answers

excellent blog with informative content... Selenium Training Institute in Chennai | Selenium Training Institute in Chennai | Selenium Training Institute in Medavakkam | Selenium Training Institute in Tharamani

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

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

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

Such a great information, Graphic designing course in Chandigarh Tally training in Chandigarh

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.

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.

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.

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

Total Visits

Feature video.

' border=

  • Conversion Functions OBIEE 12c Conversion Functions OBIEE Conversion Functions The conversion functions convert a value from one form to another.  ...

' border=

Join the Club

  • Creating Analyses and Dashboards in Oracle Transactional Business Intelligence
  • Report Data
  • Create Analyses

Advanced Techniques: Reference Stored Values in Variables

You might want to create an analysis whose title displays the current user's name. You can do this by referencing a variable.

You can reference several different types of variable in your analyses, dashboards, and actions: session , presentation , request , and global . Content authors can define presentation, request, and global variables themselves.

Type of Variable Defined in Defined by More Information

Presentation

Prompts for analyses and dashboards

Content authors

Request

Prompts for analyses and dashboards

Content authors

Global

Analyses

Administrators

and

About Session Variables

Session variables are initialized when a user signs in.

These variables exist for each user for the duration of their browsing session and expire when the user closes the browser or signs out. There are two types of session variable: system and non-system.

System Session Variables

There are several system session variables that you can use in your reports and dashboards.

The system session variables have reserved names so you can’t use them for any other kind of variable.

System Session Variable Description Example SQL Query Value (Variable dialog)

PORTALPATH

Identifies the default dashboard a user sees when they sign in (they can override this preference after signing in).

To display ‘mydashboard’ when a user signs in:

TIMEZONE

Specifies the default time zone for a user when they sign in.

A user’s time zone is typically populated from the user’s profile. Users can change their default time zone through preferences (My Account).

To set the time zone when a user signs in:

DATA_TZ

Specifies an offset from the original time zone for data.

This variable enables you to convert a time zone so that users see the appropriate zone.

To convert time data to Eastern Standard Time (EST):

This example means Greenwich Mean Time (GMT) - 5 hours

DATA_DISPLAY_TZ

Specifies the time zone for displaying data.

To display Eastern Standard Time (EST):

This example means Greenwich Mean Time (GMT) - 5 hours

Non-System Session Variables

The non-system session variables are named and created in your semantic model.

For example, your data modeler might create a SalesRegion variable that initializes to the name of a user's sales region when they sign in.

About Repository Variables

A repository variable is a variable that has a single value at any point in time.

Repository variables can be static or dynamic. A static repository variable has a value that persists and doesn’t change until the administrator changes it. A dynamic repository variable has a value that is refreshed by data returned from queries.

About Presentation Variables

A presentation variable is a variable that you can create as part of the process of creating a column prompt or a variable prompt.

Type Description

Column prompt

A presentation variable created as part of a column prompt is associated with a column, and the values that it can take come from the column values.

To create a presentation variable as part of a column prompt, in the New Prompt dialog, you must select Presentation Variable in the Set a variable field. Enter a name for the variable in the Variable Name field.

Variable prompt

A presentation variable created as part of a variable prompt isn’t associated with any column, and you define the values that it can take.

To create a presentation variable as part of a variable prompt, in the New Prompt dialog, you must select Presentation Variable in the Prompt for field. Enter a name for the variable in the Variable Name field.

The value of a presentation variable is populated by the column or variable prompt with which it was created. That is, each time a user selects one or more values in the column or variable prompt, the value of the presentation variable is set to the value or values that the user selects.

About Request Variables

A request variable enables you to override the value of a session variable but only for the duration of a database request initiated from a column prompt. You can create a request variable as part of the process of creating a column prompt.

You can create a request variable as part of the process of creating one of the following types of dashboard prompts:

A request variable that is created as part of a column prompt is associated with a column, and the values that it can take come from the column values.

To create a request variable as part of a column prompt, in the New Prompt dialog, you must select Request Variable in the Set a variable field. Enter the name of the session variable to override in the Variable Name field.

A request variable that is created as part of a variable prompt isn’t associated with any column, and you define the values that it can take.

To create a request variable as part of a variable prompt, in the New Prompt dialog (or Edit Prompt dialog), you must select Request Variable in the Prompt for field. Then enter a name of the session variable that you want to override in the Variable Name field.

The value of a request variable is populated by the column prompt with which it was created. That is, each time a user selects a value in the column prompt, the value of the request variable is set to the value that the user selects. The value, however, is in effect only from the time the user presses the Go button for the prompt until the analysis results are returned to the dashboard.

Certain system session variables (such as, USERGUID or ROLES) can’t be overridden by request variables. Other system session variables, such as DATA_TZ and DATA_DISPLAY_TZ (Timezone), can be overridden if configured in the Oracle BI Administration Tool.

Only string and numeric request variables support multiple values. All other data types pass only the first value.

About Global Variables

A global variable is a column created by combining a specific data type with a value. The value can be a Date, Date and Time, Number, Text, and Time.

The global variable is evaluated at the time the analysis is executed, and the value of the global variable is substituted appropriately.

Only users with the BI Service Administrator role can manage (add, edit, and delete) global variables.

You create a global value during the process of creating an analysis by using the Edit Column Formula dialog. The global variable is then saved in the catalog and made available to all other analyses within a specific tenant system.

Create Global Variables

You can save a calculation as a global variable then reuse it in different analyses. By just creating a global variable, you don’t have to create a new column in the Data Modeler .

  • Open the analysis for editing.
  • Select Edit Formula to display the Column Formula tab.
  • Click Variable and select Global .

"Base Facts"."1- Revenue"*@{global.variables.gv_qualified}

  • If you’re selecting "Date and Time" as the data type, then enter the value as in the following example: 03/25/2004 12:00:00 AM
  • If you’re entering an expression or a calculation as a value, then you must use the Text data type, as in the following example: "Base Facts"."1- Revenue"*3.1415
  • Click OK . The new global variable is added to the Insert Global Variable dialog.
  • Select the new global variable that you just created, and click OK . The Edit Column Formula dialog is displayed with the global variable inserted in the Column Formula pane. The Custom Headings check box is automatically selected.
  • Enter a new name for the column to which you have assigned a global variable to reflect the variable more accurately.

Syntax for Referencing Variables

You can reference variables in analyses and dashboards.

How you reference a variable depends on the task that you’re performing. For tasks where you’re presented with fields in a dialog, you must specify only the type and name of the variable (not the full syntax), for example, referencing a variable in a filter definition.

For other tasks, such as referencing a variable in a title view, you specify the variable syntax. The syntax that you use depends on the type of variable as described in the following table.

Type Syntax Example

Session

@{biServer.variables['NQ_SESSION.variablename']}

where variablename is the name of the session variable, for example DISPLAYNAME.

@{biServer.variables['NQ_SESSION.SalesRegion]}

Repository

@{biServer.variables.variablename}

or

@{biServer.variables['variablename']}

where variablename is the name of the repository variable, for example, prime_begin

@{biServer.variables.prime_begin}

or

@{biServer.variables['prime_begin']}

Presentation or request

@{variables.variablename}[format]{defaultvalue}

or

@{scope.variables['variablename']}

where:

variablename is the name of the presentation or request variable, for example, MyFavoriteRegion.

(optional) format is a format mask dependent on the data type of the variable, for example #,##0, MM/DD/YY hh:mm:ss. (Note that the format isn’t applied to the default value.)

(optional) defaultvalue is a constant or variable reference indicating a value to be used if the variable referenced by variablename isn’t populated.

scope identifies the qualifiers for the variable. You must specify the scope when a variable is used at multiple levels (analyses, dashboard pages, and dashboards) and you want to access a specific value. (If you don’t specify the scope, then the order of precedence is analyses, dashboard pages, and dashboards.)

When using a dashboard prompt with a presentation variable that can have multiple values, the syntax differs depending on the column type. Multiple values are formatted into comma-separated values and therefore, any format clause is applied to each value before being joined by commas.

@{variables.MyFavoriteRegion}{EASTERN REGION}

or

@{MyFavoriteRegion}

or

@{dashboard.variables['MyFavoriteRegion']}

or

(@{myNumVar}[#,##0]{1000})

or

(@{variables.MyOwnTimestamp}[YY-MM-DD hh:mm:ss]{)

or

(@{myTextVar}{A, B, C})

Global

@{global.variables.variablename}

where variablename is the name of the global variable, for example, gv_region. When referencing a global variable, you must use the fully qualified name as indicated in the example.

The naming convention for global variables must conform to EMCA Scripting language specifications for JavaScript. The name must not exceed 200 characters, nor contain embedded spaces, reserved words, and special characters. If you’re unfamiliar with JavaScripting language requirements, consult a third party reference

@{global.variables.gv_date_n_time}

You can also reference variables in expressions. The guidelines for referencing variables in expressions are described in the following topics:

Session Variables

Presentation variables, repository variables.

You can use the following guidelines for referencing session variables in expressions.

  • Include the session variable as an argument of the VALUEOF function.
  • Enclose the variable name in double quotes.
  • Precede the session variable by NQ_SESSION and a period.
  • Enclose both the NQ_SESSION portion and the session variable name in parentheses.

For example:

"Market"."Region"=VALUEOF(NQ_SESSION."SalesRegion")

You can use the following guidelines for referencing presentation variable in expressions.

When referencing a presentation variable, use this syntax:

@{ variablename }{ defaultvalue }

where variablename is the name of the presentation variable and defaultvalue (optional) is a constant or variable reference indicating a value to be used if the variable referenced by variablename isn’t populated.

To type-cast (that is, convert) the variable to a string or include multiple variables, enclose the entire variable in single quotes, for example:

'@{user.displayName}'

If the @ sign isn’t followed by a {, then it’s treated as an @ sign. When using a presentation variable that can have multiple values, the syntax differs depending on the column type.

Use the following syntax in SQL for the specified column type in order to generate valid SQL statements:

Text — (@{ variablename }['@']{' defaultvalue '})

Numeric — (@{ variablename }{ defaultvalue })

Date-time — (@{ variablename }{timestamp ' defaultvalue '})

Date (only the date) — (@{ variablename }{date ' defaultvalue '})

Time (only the time) — (@{ variablename }{time ' defaultvalue '})

You can use the following guidelines for referencing repository variables in expressions.

  • Include the repository variable as an argument of the VALUEOF function.
  • Refer to a static repository variable by name.
  • Refer to a dynamic repository variable by its fully qualified name.

CASE WHEN "Hour" >= VALUEOF("prime_begin") AND "Hour" < VALUEOF("prime_end") THEN 'Prime Time' WHEN ... ELSE...END

  • Install App

Analytics Software

For appeals, questions and feedback about Oracle Forums, please email [email protected] . Please ask technical questions in the appropriate category. Thank you!

how to use presentation variable on a filter

use presentation variable in filter obiee

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

Saw Object

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 ?

Articles Related

  • OBIEE 10G/11G - The (dashboard|column) prompt
  • OBIEE - Presentation Variables
  • OBIEE - TopN
  • OBIEE - Where can I use a presentation variable ?

Which means:

  • use the presentation variable myYear
  • and if it's not yet set then use as default the maximum year of the data set.

Multiple value / select

  • OBIEE 10g: You cannot set a Presentation Variable in a Multi Select dashboard prompt in OBIEE 10g. This is expected behavior. OBIEE 10g is working as designed. A Presentation variable can assume a single value. Because of that, presentation variables are not available when using multi select prompts. See note 965224.1
  • OBIEE 11g will introduce the ability to set Presentation Variables when using multi select prompts. In 10g you can try as a workaround using more than 1 prompt.

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.

Dashboard prompt

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

  • a presentation variable
  • a OBIEE - Request variable . The request variable is a variable that you can add to the obiee logical sql (the request) to set a repository session variable.
  • Select in the Set Variable Column, the value “Presentation variable”
  • Enter a name for your presentation variable

Obiee Setting Presentation Variable

Variable prompt

variable prompt

With Javascript

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

Task Runner

  • Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers
  • Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand
  • OverflowAI GenAI features for Teams
  • OverflowAPI Train & fine-tune LLMs
  • Labs The future of collective knowledge sharing
  • About the company Visit the blog

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Get early access and see previews of new features.

Can we change the values of presentation variable in OBIEE

I want to pass the value from one analysis to another analysis. Can I use presentation variable for this purpose? If not what else can I use

  • tableau-api

Broadlands_1's user avatar

  • With this minimal information we cannot hep you. Pleaes read: stackoverflow.com/help/how-to-ask –  Aldert Commented Jul 30, 2019 at 7:53

A presentation variable can be set by prompts, not an analysis. To pass a value it depends on the kind of action you have in place to go from analysis A to B. If it's a custom built link you can add the value as filter in the URL, if it's a navigation you can use the columns of the analysis A which are sent automatically by the link etc.

Keeping it short: no, your analysis A can't set a presentation variable for analysis B, you must use a prompt to set it or use an alternative way of sending values via the navigation.

Gianni's user avatar

Your Answer

Reminder: Answers generated by artificial intelligence tools are not allowed on Stack Overflow. Learn more

Sign up or log in

Post as a guest.

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy .

Not the answer you're looking for? Browse other questions tagged oracle powerbi tableau-api obiee or ask your own question .

  • Featured on Meta
  • Upcoming initiatives on Stack Overflow and across the Stack Exchange network...
  • Announcing a change to the data-dump process
  • What makes a homepage useful for logged-in users

Hot Network Questions

  • Looking for piece name/number, it looks like a wedge with 4 studs
  • How can I write a std::apply on a std::expected?
  • Membership and offices in the Privy Council – what is the significance of the different predicates used to describe the transactions?
  • Older brother licking younger sister's legs
  • What's the price of banana?
  • How do i uninstall zed editor from my ubuntu 24
  • Had there ever been a plane crash caused by flying too high and exploding?
  • Problems recording music from Yamaha keyboard to PC
  • Motivation of inventing concept of well-ordered set?
  • Can a nonconstant function that is invariant to this affine transformation exist?
  • Do liquid items stay separate in a Bag of Holding?
  • Why were early (personal) computer connectors so bulky?
  • How did Voldemort know that Frank was lying if he couldn't use Legilimency?
  • Why is the usage of 真 in 那是个真热闹的地方 considered an error?
  • Team member working from home is distracted with kids while on video calls - should I say anything as her manager?
  • Why do the Fourier components of a piano note shift away from the harmonic series?
  • The use of Bio-weapons as a deterrent?
  • Ideas for an alternative to nuclear weapons as a deterrent?
  • Is selecting a random person from an infinite population of people an invalid premise to begin with?
  • What file format was used for binary executables on Motorola 680x0 Macintoshes?
  • 80s live-action short film with a labyrinth/elf/handprint/minotaur
  • What is it that Laura is not allowed to do?
  • How to make ssh return immediately after running background job
  • Left zero-padded string in C++

use presentation variable in filter obiee

IMAGES

  1. OBIEE

    use presentation variable in filter obiee

  2. OBIEE

    use presentation variable in filter obiee

  3. OBIEE

    use presentation variable in filter obiee

  4. OBIEE

    use presentation variable in filter obiee

  5. Oracle Business Intelligence OBIEE 101: OBIEE Referencing Presentation

    use presentation variable in filter obiee

  6. Oracle Business Intelligence OBIEE 101: OBIEE Referencing Presentation

    use presentation variable in filter obiee

VIDEO

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

  2. KONTOUR: 3

  3. Filter Using Presentation Variable

  4. 10 OBIEE 12c

  5. Linear Variable Bandpass Filter as Visual Spectrometer

  6. J2SE004- Setup and Use JDeveloper Environment

COMMENTS

  1. OBIEE 12C: use of presentation variables

    1. I have a question concerning the use of presentation variables: 1) What's the correct syntax for filtering on a presentation variable is used? You allow a user to select multiple values in a filter eg. A and B. If you use the syntax = '@ {PV} {%}' it will result in this sql: = 'A, B' which of course won't exist in the data.

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

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

  3. TIMESTAMPS and Presentation Variables

    Presentation Variables. The only way you can create variables within the presentation side of OBIEE is with the use of presentation variables. They can only be defined by a report prompt. Any value selected by the prompt will then be sent to any references of that filter throughout the dashboard page. In the prompt:

  4. OBIEE

    Dashboard prompts. iBot Headlines and text. Some examples are given below with a presentation variable "Year" and as default value the max of the year : @{Year}{max(Calendar."Calendar Year" by) } A prompt has been first created to set the presentation variable : OBIEE 10G/11G - How to set a presentation variable ?

  5. Filtering and Selecting Data for Analyses

    Filters and selection steps are applied on a column-level basis and provide two methods for limiting the data in an analysis. A filter is always applied to a column before any selection steps are applied. Steps are applied in their specified order. Filters and selection steps differ in various ways. Filters.

  6. 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 using a FILTER and IN operator it results in no Result. FILTER("HR Facts"."Headcounts" USING "Location"."Region Name" IN ('@{pv_region}{West}'))

  7. OBIEE

    The syntax for referencing presentation variables is as follows: @{variables.<variableName>}{<default>}[format] variables - (optional) variableName - a reference to an object available in the current evaluation context that is not a reserved variable name. default - (optional) - a constant or variable reference in Obiee logical sql indicating a ...

  8. PDF OBIEE Training

    • Presentation -defined in OBIEE Syntax: • @{VariableName}{<default>}[format] for repository & presentation variables • NQ_Session prefix for session variables. Variable Examples Repository Session Presentation. Presentation Variables A Perfect Pair: • Set in the Prompt • Use in the Filter. Lab 4: Using a Variable. Hints 1. Use IDs ...

  9. Advanced Techniques: Reference Stored Values in Variables

    To create a presentation variable as part of a column prompt, in the New Prompt dialog, you must select Presentation Variable in the Set a variable field. Enter a name for the variable in the Variable Name field. Variable prompt. A presentation variable created as part of a variable prompt isn't associated with any column, and you define the ...

  10. PDF Lesson 7: Variables and Dashboard Prompts

    values of Presentation variables may be used as filtering conditions for any analyses on the dashboard(s) on which the dashboard prompt is present. The use of a dashboard prompt is the only way to create a presentation variable. There is no way to just "create and populate a variable" for use in OBIEE. It must be defined in the repository ...

  11. PDF OBIEE Training: Lesson 2: Filters

    Exercise 2c: Grouping filters using AND/OR conditions . Frequently, filters may need to be applied in a specific order, or grouped together so that specific OR or AND conditional groupings can be handled. OBIEE allows the grouping of filters in that manner. 1. Open (if necessary) the . Top 10 Analysis . and use the Save As icon (to the right of ...

  12. how to use presentation variable on a filter

    I am using OBIEE 11.1.1.5.0. I have created a dashboard prompt in which I am using presentation variable name is award. I have created an analysis In that if I use presentation variable as filter e.g. Award is equal to/ is in @{award}

  13. Passing multiple values to a presentation variable

    Meanwhile checkout below KM document which explains on how to make use of Presentation Variable in Column formula based on Column Type. OBIEE 11g: Presentation Variable With Multi Value Selected Gives 'No Results' and Wrong Query Generated. (Doc ID 1418868.1)

  14. OBIEE

    About. The presentation service has some presentation variables that are reserved to give specific information. You can use them in your answer such as @ {system.currentTime} to filter depending of the current time . Be careful, the difference between upper and lowercase letter is important.

  15. OBIEE

    This article talk the manipulation of a presentation variable with a date datatype. Starting with OBIEE 10.1.3.4.1 and higher versions, Dashboard Prompt input formats and presentation variable values for DATE & DATETIME columns are standardized to YYYY-MM-DD & YYYY-MM-DD HH24:MI:SS One big mistake that is made with the date, is that people may confuse between NLS_DATE_FORMAlocalizatioOBIEE ...

  16. OBIEE 10G/11G

    a OBIEE - Request variable. The request variable is a variable that you can add to the obiee logical sql (the request) to set a repository session variable. Select in the Set Variable Column, the value "Presentation variable". Enter a name for your presentation variable. 10G.

  17. OBIEE

    Answers. You can't put the UPPER in the variable field name of the filter as it will take " UPPER (Item) " as the variable name instead of UPPER of the variable " Item ". So in the field you simply enter " Item " and then click on the checkbox "convert this filter to SQL" and there in the LSQL field you add the UPPER function around the full ...

  18. Can we change the values of presentation variable in OBIEE

    1. A presentation variable can be set by prompts, not an analysis. To pass a value it depends on the kind of action you have in place to go from analysis A to B. If it's a custom built link you can add the value as filter in the URL, if it's a navigation you can use the columns of the analysis A which are sent automatically by the link etc.