There seems to always be the occasion where you want to create a report, which will need the use of selection steps to include all the available members; but you want to override the values to keep/use with those of a dashboard prompt. Currently, as of 11.1.1.5, the UI does not make it easy enough [...]
Archive for the ‘Presentation Services’ Category
Selection Step Start with all members; but with override with prompt
Posted in Presentation Services, tagged selection steps on February 16, 2012 | Leave a Comment »
Update to Global Go Script for dashboard page scope
Posted in Presentation Services on June 24, 2011 | Leave a Comment »
The current global go script I have not only produces one ‘go’ button for all prompts on a page; but, it also has code to create required fields and required field validations. The one thing that was brought to my attention was that my current script treated the prompt collective on the page to have [...]
Scope of Dashboard Prompts
Posted in Presentation Services on June 1, 2011 | Leave a Comment »
Some may think that the scope of the prompts do not work and are broken; but, they do work and are not broken! You just need to know what it really does. So when you specify a dashboard prompt as scope-> ‘page’, what this does is say that any selections made for this prompt will [...]
Page controls sudden do not work for a report!
Posted in Presentation Services on April 21, 2011 | Leave a Comment »
I came across this bug/issue that some may encounter. The issue is with the page controls for the table view and them not working. If you come across it that the page controls do not work or navigate to the next page of records, then the first thing to look at is your compound view [...]
Calculating grand total as a column in Table View
Posted in Presentation Services on April 21, 2010 | Leave a Comment »
Calculating grand total column or % of grand total is easy in pivot table view. But how can I create the same in a table view? Well in table view you can create a grand total row with the table view options! But, that is not what we want. We want it so that you [...]
Creating New Web Catalog
Posted in Presentation Services on April 8, 2010 | 3 Comments »
I have been seeing a lot where people take paint or samplesales webcat and either cloning it or modifying it to make a new webcat. This has its issues and problems. For one, you inherit all the users and privileges that are there, especially if you were using and modifying this before you decided that [...]
Lessons in Filters and the ‘is prompted’ operator
Posted in Presentation Services on March 4, 2010 | 2 Comments »
It has been a long time, couple of months, since I last posted. But busy beaver that I am, took me away from blogging. Anyways, I got a breather and will add-on. Filters and the ‘is prompted’ operator. Many might think they know how this works and get shocked when things just don’t quite work [...]
Required Field Validation: Addition to the Global “Go” Button
Posted in Presentation Services on October 17, 2009 | 4 Comments »
I have been asked to create custom functionality whereby certain dashboard prompts are required, and the user should not be able to continue until all required fields are selected before they can query. So I ventured out and created the following script below to do just that. This script is in addition to the ‘Global’ [...]
Stop reports/queries from being automatically fired from dashboard
Posted in Presentation Services on August 24, 2009 | Leave a Comment »
There are alot of users that wish that reports within dashboards would not fire automatically once entering a dashboard or dashboard page. So what is the solution? There is a pretty good solution to this problem out there that uses the concept of guided navigation; but, it doesn’t work. On the surface it looks like [...]
Drillable logical columns
Posted in Administration Tool, Presentation Services on August 24, 2009 | Leave a Comment »
On a project recently, there arose an issue where logical columns that were not explicitly added to a hierarchy where suddenly drillable! What would cause that? Did someone change a property? After careful analysis, I found out that there are 2 things that will make logical columns (not explicitly set in a hierarchy level) become [...]
