obiee-oracledb.blogspot.com

Vishal's blog

Friday, 14 April 2017. OBIEE 11G RPD bypass using Private Variable Columns. We had a requirement where the user wanted to be able to get into the tool and change his formula and also wanted the change to be reflected across all his reports. Changing the formula in each report was a lot of effort and hence not practical. This blog talks about a 6 possible ways to handle this requirement and introduces the concept of Private Variable Columns. Posted by Vishal Pathak. Labels: Command line catalog manager.

http://obiee-oracledb.blogspot.com/

OVERVIEW OF obiee-oracledb.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

20

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR OBIEE-ORACLEDB.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

June

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Wednesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.9 out of 5 with 13 reviews

5 star

6

4 star

2

3 star

4

2 star

0

1 star

1

Hey there! Start your review of obiee-oracledb.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

1.3 seconds

FAVICON PREVIEW

16x16

CONTACTS AT OBIEE-ORACLEDB.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

20

SSL

EXTERNAL LINKS

31

SITE IP

172.217.10.129

LOAD TIME

1.281 sec

SCORE

6.2

PAGE TITLE

Vishal's blog | obiee-oracledb.blogspot.com Reviews

<META> DESCRIPTION

Friday, 14 April 2017. OBIEE 11G RPD bypass using Private Variable Columns. We had a requirement where the user wanted to be able to get into the tool and change his formula and also wanted the change to be reflected across all his reports. Changing the formula in each report was a lot of effort and hence not practical. This blog talks about a 6 possible ways to handle this requirement and introduces the concept of Private Variable Columns. Posted by Vishal Pathak. Labels: Command line catalog manager.

<META> KEYWORDS

1 tweet

2 1 comments

3 dashboard

4 global variable

5 8 comments

6 labels conditional filtering

7 gourl

8 html

9 javascript

10 multiple values

CONTENT

Page content here

KEYWORDS ON PAGE

tweet,1 comments,dashboard,global variable,8 comments,labels conditional filtering,gourl,html,javascript,multiple values,presentation variables,2 comments,labels batch script,deployment log,grep,hosts file,iexpress,obiee 11g rpd,opmnctl,plink,pscp,facts

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Vishal's blog | obiee-oracledb.blogspot.com Reviews

https://obiee-oracledb.blogspot.com

Friday, 14 April 2017. OBIEE 11G RPD bypass using Private Variable Columns. We had a requirement where the user wanted to be able to get into the tool and change his formula and also wanted the change to be reflected across all his reports. Changing the formula in each report was a lot of effort and hence not practical. This blog talks about a 6 possible ways to handle this requirement and introduces the concept of Private Variable Columns. Posted by Vishal Pathak. Labels: Command line catalog manager.

INTERNAL PAGES

obiee-oracledb.blogspot.com

1

Vishal's blog: Making OBIEE 11g Evaluate function dynamic

http://obiee-oracledb.blogspot.com/2015/05/making-obiee-11g-evaluate-function.html

Sunday, 3 May 2015. Making OBIEE 11g Evaluate function dynamic. We know that we can use the evaluate function to call any function stored on the database and pass arguments to it. What if we have a requirement to use different database functions for the same column based on different selections made by the user. This article talks about a method to handle this requirement. Before you start, make sure that EVALUATE SUPPORT LEVEL = 2; is set in nqsconfig.ini. Posted by Vishal Pathak. How can we use evaluat...

2

Vishal's blog: Drill-able hierarchical charts in OBIEE 11g

http://obiee-oracledb.blogspot.com/2014/08/drill-able-charts-in-obiee-11g.html

Tuesday, 5 August 2014. Drill-able hierarchical charts in OBIEE 11g. This is a discovery more than a solution. OBIEE 11g lets us use Hierarchical column as dimensional attributes for charts. Using hierarchical columns in chart enables us to create drill-able charts. The default view can be the top level view and the user can then drill to a more granular view in the chart on the fly. Note that the Time total label (highlighted in the above screenshot) is drill-able. Posted by Vishal Pathak. I am an Oracl...

3

Vishal's blog: Privilege to see hidden objects in OBIEE 11g

http://obiee-oracledb.blogspot.com/2014/08/privilege-to-see-hidden-objects-in.html

Saturday, 9 August 2014. Privilege to see hidden objects in OBIEE 11g. My client wanted to hide some of the reports from the users and release them at a later date. The however wanted a set of users to have the privilege to see hidden objects. Let us see the process to achieve this objective. While we can directly assign the privilege to the users, it is far better to do the following. 1 Create a power user group. 2 Create a new role. 3 Assign the group to the role. 4 Assign the desired users to the group.

4

Vishal's blog: Non Standard SQL in BIP 11g - Dynamic query implementation

http://obiee-oracledb.blogspot.com/2014/08/non-standard-sql-in-bip-11g-dynamic.html

Sunday, 31 August 2014. Non Standard SQL in BIP 11g - Dynamic query implementation. This blog post talks about a BIP 11g method of achieving the same result. We are essentially talking about writing dynamic queries in BIP. We will use BIP 11g's Non Standard SQL. Feature to achieve this objective. We will follow the following steps:. 1 Create 2 tables and feed data into them. 2 Create a BIP 11g data model that has a Non-Standard SQL. 3 Create a simple BIP report and check the implementation. 3 Create a pa...

5

Vishal's blog: Easy method to create BIP 11g reports on top of OBIEE dashboards

http://obiee-oracledb.blogspot.com/2014/12/easy-method-to-create-bip-11g-reports.html

Friday, 12 December 2014. Easy method to create BIP 11g reports on top of OBIEE dashboards. This blog talks about a quick way to create BIP reports on top of OBIEE dashboards. I have used 2 graphs from Sample Sales catalog for the purpose of this demo. Select the Print Options link. Select Custom Print Layouts - Create Layouts. Thats it, OBIEE will do all the work of creating a layout and a data model for you. Hit the View Report button to see your report. Posted by Vishal Pathak. View my complete profile.

UPGRADE TO PREMIUM TO VIEW 15 MORE

TOTAL PAGES IN THIS WEBSITE

20

LINKS TO THIS WEBSITE

addidici.com

OBIEE Blogs and Links | Addidici – 16 Years of OBIEE and OBI Application

http://addidici.com/index.php/obiee-blogs-and-links

Addidici – 16 Years of OBIEE and OBI Application. Addidici 16 Years OBIEE and OBI Applications. OBIEE Blogs and Links. Oracle First Aid Kit. Oracle On The Web. OBIEE Blogs and Links. There are so many blogs out there now I thought I would put them in a table. Please send me your links to add here. I am also moving this list to an Apex Database: try blogs.addidici.com. OBIEE and Siebel Analytics. Http:/ www.addidici.com/index.php/obiee-news/. Mix of technical, market opinion and the sailing article. Http:...

UPGRADE TO PREMIUM TO VIEW 30 MORE

TOTAL LINKS TO THIS WEBSITE

31

OTHER SITES

obiee-bi.blogspot.com

OBIEE

OBIEE – Write Back. OBIEE – Navigation from one report to a different . OBIEE – Using single GO button for all prompts rat. OBIEE – Dynamic Rolling Month Supporter. OBIEE – Column Tips in report columns in Dashboard. Passing values across pages using report navigatio. View my complete profile. Friday, April 8, 2011. OBIEE – Write Back. Your dashboard has a requirement to update a record in the database from OBIEE report. You can also grant write-back privilege to any LDAP Group here. Go to Answers and cr...

obiee-bip.blogspot.com

Goushalya's Journal on OBIEE

Goushalya's Journal on OBIEE. Disabling 'More Products' Menu and its Application Links. More Products' Menu on the User Interface provides you the access to Delivers, BI Publisher, Marketing, Disconnected Analytics Links and the download for the Microsoft Desktop Add-in for Oracle BI. Very often we get requirements to disable some of these links or the entire 'More Products' Menu. This post we'll discuss two methods of disabling the link access. Td class="@{classPrefix}Sep" - /td. Img src="fmap:common/mo...

obiee-blog.blogspot.com

STrudeau's OBIEE Blog

Wednesday, February 29, 2012. The objective of this POC is to create a prompt that will allow a user to select a metric (from a list of metrics) and enter an amount to filter it by. This is accomplished by creating three separate prompts and storing the values in Presentation Variables. Then your report can use these Presentation Variables to filter your results. Create an answers report that contains the metrics that you want to filter. Save this report as "POC Metric Selector". The important thing to n...

obiee-blog.info

OBIEE Blog | OBIEE Blog with focus on smart business intelligence – Oracle Business Intelligence tips, best practices, and advice

OBIEE-related Jobs & Contract Opportunities. 65000 rows CSV Limit – hidden parameter. April 26, 2016. I have spent 1,5 hours trying to figure this out. It seems as unnecessary item and a well-hidden one. This is valid for OBIEE 12c as well. You have upgraded your OBIEE 11g instance to OBIEE 11.1.1.9.0. Now when you export reports to CSV format file, you do not get more than 65000 rows downloaded. In earlier versions of OBIEE 11g, you could download more than 65000 rows. 8211;This Configuration setting is...

obiee-oracledb.blogspot.com

Vishal's blog

Friday, 14 April 2017. OBIEE 11G RPD bypass using Private Variable Columns. We had a requirement where the user wanted to be able to get into the tool and change his formula and also wanted the change to be reflected across all his reports. Changing the formula in each report was a lot of effort and hence not practical. This blog talks about a 6 possible ways to handle this requirement and introduces the concept of Private Variable Columns. Posted by Vishal Pathak. Labels: Command line catalog manager.

obiee-rk.blogspot.com

OBIEE Blogs

This blog is just for sharing my knowledge of oracle BI. Saturday, 17 November 2012. Debug Security Log ON/OFF. Very simple configuration but import if you want to debug the Security which is been playing vital role every where, Please perform the following steps in order to set the debug on/off. 1) Log in to. 2) Navigate over left pane and select. From the available servers. Option available in Debug Scopes and Attributes table. 6) Click on Enable. Button at top or bottom of the table. Http:/ oracle&#46...

obiee-tips.blogspot.com

OBIEE (Oracle Business Intelligence) Tips

OBIEE (Oracle Business Intelligence) Tips. This is a blog detailing the interesting (and sometimes not so interesting) features of OBIEE which I come across in my day-to-day life. Friday, March 11, 2011. Removing the PDF/HTML print option. I saw a post in the OTN forums asking how to disable the pdf option in the print menu for dashboards, if you want to do this for a particular dashboard then you can do this through javascript, here is a simple example:. Var dateHeaderPos = findPos(dateHeaderDiv);.