If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dynamic default values for Active Report Variables

Started by Ogram, 03 Feb 2014 06:48:02 AM

Previous topic - Next topic

Ogram

Hello gurus,

A simple question really - I working on a mobile report that is to be used on a daily basis by dozens of people. To increase usability I'd like to have one of the time-related variables (day-level date) to default to previous day. I could easily set a fixed date but this, as you can imagine, is far from ideal solution. Neither do I want to leave the variable without setting a default as this also forces the user to select a date to be able to see the values.

There's a possible workaround that just popped into my mind while I was writing this - I might create a default card that uses a 'Previous Day' element instead of a 'Date' and have it show up when the related variable is empty the deck would switch over to the proper card when the user chooses a value for the date variable. I'd like your comments on the first paragraph, just in case I'm missing something here.

Thanks

Ogram

Quote from: Ogram on 03 Feb 2014 06:48:02 AM
There's a possible workaround that just popped into my mind while I was writing this - I might create a default card that uses a 'Previous Day' element instead of a 'Date' and have it show up when the related variable is empty the deck would switch over to the proper card when the user chooses a value for the date variable.

Works like a charm although it's not an ideal solution. What I did was I moved the contents that were modified by the said variable into a deck and added a default card which shows up when a certain variable (not the date one but one dedicated to make this workaround... well, work) is empty. Whenever user selects a date, the deck switches to a card that has identical contents but allows for the use of the date variable.

Default card - Variable 'ShowDeck' is empty

List1
[Yesterday] [Salesperson] [Revenue]


Prompt-filtered Card - 'Showdeck' activates this, 'Showdeck' is given a value whenever user selects a value for the date prompt

List1
[Date] [Salesperson] [Revenue]


My solution is presented here just in case someone else is struggling with this and needs a stopgap solution.

Cheers

MFGF

Meep!