Blog

Financials Objects for Drilling Demos

: Created on Friday, 16 March 2007 21:00; Written by Larry Grey

Although I put together a previous posting on Drilling and nVision, I only included a single nVision drill layout to illustrate this. I already put together comprehensive packages to show:

Reporting in HCM (Orig Posting, Demo, and Code)
Reporing in Student Admin (Orig Posting, Demo, and Code)

Code for Financials Drilling to Pages and Queries (among other things).

I decided to put together a package for Reporting in Financials (Orig Posting and Code). As with the other packages, the code includes a working example with our nVision drilling product.

Labels: Drilling, nVision, Query

Add your comment

yvComment v.2.00.2

News Archives

► 2012
- ► April
  - • 23 - TCU Goes Live with PeopleMobile
- ► March
  - • 29 - You are now free to move about the enterprise
  - • 14 - Alliance 2012: Pre-conference Training Sessions
  - • 13 - Gartner’s Top Predictions for IT Organizations and Users, 2011
- ► February
  - • 29 - IDC Smartphone Adoption Survey
  - • 28 - HEUG Alliance 2012 - Customer Mobile presentations
  - • 13 - PeopleSoft Mobile on BlackBerry
- ► January
  - • 30 - What's New in PeopleTools 8.52 - Video Available
  - • 23 - Getting Started in PeopleSoft Mobile YouTube Video
  - • 12 - JQuery Mobile test lab
  - • 11 - UK and EU customer visits
  - • 09 - Drilling URLs and Pagelet WIzard
► 2011
- ► December
  - • 29 - Mobile Implementation Considerations for PeopleSoft
- ► September
  - • 16 - HEUG forum post from TCU about our Mobile solution
  - • 08 - BI Publisher versus PeopleSoft XML Publisher
  - • 08 - Best Practices in XML Publisher Reporting
  - • 05 - Advanced nVision tips and techniques
  - • 05 - Best Practices in implementing PeopleSoft Self Service
  - • 05 - The Lane County Single Signon Story
  - • 05 - Taming Change - The University of Western Ontario's change management journey
  - • 04 - Amazon.com redesigns its website around mobile
- ► July
  - • 09 - Featured Vendor - Illinois Technology Association
  - • 24 - Kerberos tickets at login time on Mac OS X
  - • 29 - Mobile for PeopleSoft
- ► June
- ► May
  - • 26 - Chicago Office Opens
  - • 26 - HIUG Interact conference 2011
- ► March
  - • 04 - Navigation Changes in PeopleTools 8.51
  - • 10 - Powerpoint from Development Best Practices Webinar
  - • 21 - PS/nVision is not configured properly on this workstation
  - • 23 - HEUG Alliance 2011
  - • 23 - PeopleSoft Test Framework Tables
- ► February
  - • 01 - QVC Chooses Grey Sparling for Version Control
  - • 02 - Grey Sparling is Hiring - Solutions Architect
  - • 23 - Oracle Customer Advisory Board meeting
► 2010
- ► October
  - • 01 - PeopleSoft Testing Framework - Supply Chain (Inventory, Purchasing, Procurement, and Payables)
  - • 13 - Introducing Automatic URL Shortening for your PeopleSoft URLs (automatic bit.ly or TinyURL for PeopleSoft)
- ► September
  - • 03 - Tuxedo Listening on Multiple IP addresses
  - • 10 - PeopleTools 8.51 Initial Impressions
  - • 14 - Your security options are set improperly. Please contact your security administrator.
  - • 20 - Advanced PeopleSoft Security Audit - OpenWorld 2010
  - • 20 - PeopleSoft Enterprise Release 9.1 Adoption and Roadmap
- ► August
  - • 21 - Adding Hints to Dynamically Generated App Engine SQL
  - • 23 - PeopleSoft Component Interface Testing Tools
- ► July
  - • 09 - Syntax Highlighting for PeopleSoft SQL Traces
- ► June
- ► April
  - • 06 - The PeopleSoft/IBM backstory
- ► March
  - • 10 - Please don't mirror the site every 5 seconds
- ► February
  - • 21 - Java PeopleSoft
- ► January
  - • 01 - Diff/Merge Page in PeopleSoft Application Designer
► 2009
- ► December
  - • 10 - Related Content Feature in PeopleTools 8.5
- ► November
  - • 08 - Application Designer on Linux
- ► October
  - • 12 - OpenWorld 09 - PeopleSoft Upgrades - A Customer's Perspective
  - • 12 - OpenWorld 09 - PeopleSoft 9.1 Overview / Keynote
  - • 13 - OpenWorld 09 - Oracle Enterprise Manager with PeopleSoft
  - • 13 - OpenWorld 09 PeopleSoft 9.1 Financials Overview
  - • 13 - OpenWorld 09 PeopleTools 8.5 Customer Perspective
  - • 25 - In Depth - PeopleTools 8.50 RSS Feed Publishing Framework
- ► September
  - • 21 - PeopleTools 8.50 RSS Feed Publishing Framework
- ► August
  - • 04 - PeopleTools on Vista
  - • 05 - Sun Continuous Integration Server (aka Hudson
  - • 10 - Oracle JDeveloper 11gR1 with PeopleSoft
  - • 11 - Oracle JDeveloper 11gR1 with PeopleSoft - part 2
  - • 24 - Protecting PeopleSoft against "Real-Time" Secure ID Snatching
  - • 27 - Figuring out where your Financial Data came from
- ► July
  - • 08 - Using PeopleSoft Performance Monitor
  - • 24 - Increasing System Availability with PeopleSoft
- ► June
  - • 28 - Security Issues With PeopleSoft Production Refreshes
  - • 22 - Automating Forced Windows Logout for Kiosks
- ► May
  - • 02 - PeopleSoft Test Automation
  - • 10 - Functional Testing of PeopleSoft Applications
  - • 19 - PeopleCode Unicode Variable Names
  - • 29 - Multiple field nPlosion for Peoplesoft nVision
- ► April
  - • 02 - Testing PeopleSoft LDAP integration with Active Directory
  - • 02 - New Webinars Posted
  - • 02 - Getting more from MetaLink (soon to be "My Oracle Support")
  - • 15 - PeopleTools Patches
  - • 25 - IBM's Oracle emulation
  - • 26 - Issues with Dynamic Roles in PeopleSoft
  - • 29 - Oracle VM Templates for PeopleSoft Now Available
- ► March
  - • 03 - PeopleCode Editor Shortcuts
  - • 10 - Emailing Scheduled PS/Query Results
  - • 10 - Version Control for PeopleSoft demo
  - • 17 - Una historia de PeopleTools
  - • 21 - ActiveDirectory and PeopleCode integration
  - • 25 - Introducing Code.GreySparling.com
- ► February
  - • 03 - Remote access to PSADMIN
  - • 04 - One time passwords
  - • 05 - Keystroke loggers
  - • 07 - Fixing PeopleSoft Workflow Email Notifications
  - • 07 - Charles Phillips named to economic recovery board
  - • 15 - Out of Available Memory error running Application Engine
  - • 20 - Grey Sparling "PeopleSoft Experts" Webinar Series
  - • 23 - New Webinar: Social Networking with your PeopleSoft Application
  - • 23 - New Webinar: Advanced Troubleshooting for your PeopleSoft Environment
  - • 23 - New Webinar: Meet the Experts Virtual Open Roundtable
  - • 23 - New Webinar: What you should know about the PeopleSoft Ecosystem
- ► January
  - • 22 - Which PeopleSoft system am I working in?
  - • 26 - Taking control of your build files
► 2008
- ► November
  - • 14 - Overlapping Text in PeopleSoft and Safari 3.x
- ► September
  - • 04 - Initial Testing with PeopleSoft using the Chrome browser
  - • 06 - One in a million
  - • 11 - Workday slowly following the PeopleSoft path
  - • 15 - Helping our friends in the Financial Services Industry
  - • 22 - LDAP Query Syntax Tips
  - • 28 - OpenWorld Wrap-up
- ► August
  - • 01 - Getting better Control of your reports.
  - • 09 - Oracle Virtual Machine Templates
  - • 19 - Correction on 2007 Open World session writeup
- ► July
  - • 06 - PeopleSoft IVR Integration the easy way
  - • 07 - PeopleSoft telephony two factor authentication
  - • 08 - nVision using Queries intricacies
  - • 11 - Tightening Data Security in your PeopleSoft Environment
  - • 21 - OpenWorld sessions from Oracle Mix voting winners announced
- ► May
  - • 20 - 2008 PHRUG Wrap-Up
- ► April
  - • 09 - Reporting against multiple Setids in PeopleSoft
  - • 11 - Firewall Product as Savior
  - • 13 - Collaborate 2008
  - • 15 - International Rollouts of PeopleSoft - Do's and Don'ts
  - • 15 - Strengthening Data Privacy in PeopleSoft
  - • 23 - Enterprise RSS Day
  - • 25 - Collaborate Day 1 - A43910: Business Intelligence – A look at Oracle's Business Intelligence tool out of the box
  - • 25 - Collaborate Day 1 - A43910: Business Intelligence – A look at Oracle's Business Intelligence tool out of the box
  - • 25 - Collaborate Day 2 - E40790- PeopleSoft Executive Update with Doris Wong
- ► March
  - • 28 - Setting Report Retention Limits dynamically for Report Manager
  - • 07 - Grey Sparling 2008 Spring Events
  - • 14 - Can you use Winter or Node-Oriented Trees in GL?
  - • 13 - Baby steps with Reporting against PeopleSoft
  - • 12 - Code Escrow 2.0
  - • 17 - Links not Automatically Opening a Page
  - • 20 - Creating a Shortcut to Opening a Query in Windows Query
  - • 26 - Client/Server Single Signon for PeopleSoft
- ► February
  - • 14 - Using Instant Messaging to Enrich PeopleSoft
  - • 19 - Ramifications of Annoying your co-workers in a call center...
  - • 29 - Using Flash for End-User Training
- ► January
  - • 09 - Silly Blog Games
  - • 09 - Upgrading to Fusion
  - • 24 - Helpdesk support in the middle ages
► 2007
- ► December
  - • 05 - "More Advanced Reporting Tips and Techniques for PeopleSofft Enterprise" powerpoint
- ► November
- ► October
  - • 08 - What does SAP's Acquisition of Business Objects Mean?
  - • 10 - Opening up a Performance or Development Document from a URL
  - • 11 - Re-Posted yesterday's item.
  - • 12 - BEA acquisition impact for PeopleSoft customers?
  - • 23 - Looks like someone didn't implement workflow for approving vendor payment changes.
  - • 25 - A Better Way to Manage PeopleSoft Windows Services
- ► September
  - • 21 - Creating Optional Parameters for a PeopleSoft page
  - • 21 - Drilling Deeper into PeopleSoft Pages
  - • 24 - Code to Drill to any Chartfield Combination on Journal Entry Page
  - • 25 - Insatiable Application Classes
  - • 26 - Security Zone Management in Internet Explorer
- ► July
  - • 09 - Grey Sparling Excel Add-in for PeopleSoft
  - • 19 - The Good, Bad, and Ugly of our Niche...Part 1
  - • 23 - The Good, Bad, and Ugly of our Niche... Part 2
  - • 26 - The Good, Bad, and Ugly of our Niche... Part 3
- ► June
  - • 04 - Upcoming Events
- ► May
  - • 13 - History of Tree Manager
  - • 14 - Advanced VBA Hooks in nVision
  - • 15 - Post-processing Query output in Excel
  - • 24 - A Brief History of PeopleTools 9
- ► March
  - • 16 - Query and nVision Reporting in Student Admin
  - • 16 - Financials Objects for Drilling Demos
  - • 16 - Alliance Conference 2007 Wrap-Up
  - • 20 - Alliance 2007 Session Evaluations
- ► January
  - • 02 - Grey Sparling 2006 In Review
  - • 09 - Query and nVision Reporting in HCM
  - • 10 - Flash Demo of HCM ReportingFlash Demo of HCM Reporting
  - • 12 - January through March Grey Sparling Events
► 2006
- ► November
  - • 23 - Advanced Run Control Techniques for Process Scheduler
- ► October
  - • 27 - Oracle Open World 2006 Wrap-Up
  - • 18 - Query Drilling URL Feature in PeopleTools 8.5 Review
- ► September
  - • 11 - Financial Transparency Tool
  - • 15 - Report Manager Performance
  - • 19 - Little known work-around for many nVision bugs...
  - • 21 - Desktop Single Signon for PeopleSoft
  - • 29 - Open World Update - Session Popularity
- ► August
  - • 03 - Managing Processing Time Limits
  - • 04 - Presenting at Oracle OpenWorld 2006
  - • 08 - Drag and Drop stopped working in Tree Manager?!?!
  - • 13 - Associating database connections with PeopleSoft users
  - • 14 - IE August Update Crashes PeopleSoft
  - • 21 - PS/nVision and Other Reporting Techniques Presentation
  - • 23 - Application Designer Index Management tip
  - • 25 - Hiding the PeopleSoft Pagebar in all component
  - • 30 - Determing the PeopleSoft Portlet URL
  - • 30 - Passing additional parameters to PeopleSoft pages
  - • 30 - Java and PeopleCode Tips and Tricks - Part 3
- ► July
  - • 12 - New Tool for PeopleSoft Application Developer Productivity
  - • 27 - Grey Sparling Experts coming to a city near you!!!
- ► June
  - • 09 - Oracle 12 Applications User Interface
  - • 18 - Fixing PeopleSoft Copy-URL for Firefox
  - • 20 - PeopleCode and C Integration
  - • 23 - Oracle-PeopleSoft Bloggers
- ► May
  - • 04 - App Designer 3 tier login from the command line
  - • 08 - Deeper dive explanation of Siebel Analytics by Mark Rittman
  - • 13 - Application Engine Development Tips
  - • 18 - nVision with Query Prompts
  - • 18 - Little known Row Level Security hook
  - • 22 - Fixing Report Manager
- ► April
  - • 05 - Enhancing the PeopleSoft for Administrators
  - • 20 - nVision Drilling Performance and Latency
  - • 27 - PeopleSoft Single Signon
  - • 29 - nVision and Siebel Analytics
- ► March
  - • 03 - nVision Power Drilling (Pages, Queries, Drilldown Layouts, and more)
  - • 16 - nVision and Fusion
  - • 23 - Darth Ellison vs Jedi ABAP
  - • 23 - Java and PeopleCode Tips and Tricks - Part 2
- ► February
- ► January
  - • 06 - Using PS/nVision to print your trees.
  - • 06 - Using Styles and nVision
  - • 09 - Follow-on to styles and nVision
  - • 18 - Integrating GoogleTalk with PeopleSoft
  - • 19 - Dynamic PeopleSoft Security Based on Login
  - • 23 - PeopleSoft Version Control
► 2005
- ► December
  - • 27 - How Chartfields are identified in GL
  - • 27 - Materialized Views and Row Level Security
- ► November
  - • 01 - October Update
  - • 11 - Filtering nVision for date and quarter
- ► October
  - • 14 - Understanding Row Level Security
  - • 16 - Why You Should Avoid PeopleCode For Row Level Security
- ► September
  - • 16 - Handling Rogue Queries in PS/Query
  - • 20 - Using Cube Manager to solve data merging issues
  - • 29 - Drilling to other content in nVision
  - • 29 - Hierarchical Reporting in nVision
- ► August
  - • 01 - nVision hanging problem
  - • 02 - Field Level Security in PS/Query
  - • 03 - Magic with Content Cells
  - • 04 - Accessing data from two different database instances
  - • 08 - PeopleSoft Trivia - the source control rule...
  - • 12 - Inside PeopleSoft trees - or - Photosynthesis at PeopleSoft
  - • 19 - Report Distribution with 3rd party solutions...
  - • 22 - Organizing reports in Report Manager prior to Tools 8.4
  - • 23 - Meet the Experts
  - • 26 - Improving the drilling usability in nVision
  - • 31 - Understanding Setids and Business Units
- ► July
  - • 20 - Doing Ledger-based nVision reporting in EPM
  - • 21 - To Customize or not to Customize, that is the question...
  - • 22 - Tricking PeopleSoft to do what you want - Part 1
  - • 23 - NorCalPRUG Meeting Notes -- Morning
  - • 25 - NorCalPRUG Meeting Notes -- PS/nVision vs. e.Spreadsheet
  - • 25 - Strategic Structure Alignment, Part 1
  - • 25 - NorCalPRUG Meeting Notes -- Technical Roundtable Notes
  - • 25 - Knowledge Networks versus Organization Structures
  - • 26 - nVision performance tuning
  - • 28 - Embedding Macros into nVision reports
  - • 29 - Training PS/Query to do new tricks...

Blog

Financials Objects for Drilling Demos

Code for Financials Drilling to Pages and Queries (among other things).

Add your comment

News Archives

Recent Comments

Tags

Your name:
Comment: