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

Author Topic: Filter values  (Read 6989 times)

Offline TheDarkKnight

  • Full Member
  • ***
  • Join Date: Jan 2010
  • Posts: 34
  • Forum Citizenship: +0/-0
Filter values
« on: 20 Feb 2013 07:51:29 am »
Hi Friends,
i have a adhoc package with a column 'Yearweek ' in a regular dimension.

when i try to filter in Query studio for Yearweek, the format to filter comes as a 'Range' to type (From value & to value).
My need is to have this as select type filter where users can choose the values.

I tried to convert to varchar and implement. In this case, the filter appears as select type but i get a problem here.
For some reason, Rollup of fact values is not working when viewed across Yearweeks when converted to character type.

i also tried having Yearweek (integer type) as business key and Yearweek_C(varchar) as Membercaption. and made Yearweek_C as visible. Again, rollup is not working.

Is there a way, to make filter type to appear as Select for Integers as in above case. or any other options, will be very glad to know.

Regards
TDK



Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,643
  • Forum Citizenship: +676/-10
  • Cognos Software Muppet
Re: Filter values
« Reply #1 on: 01 Mar 2013 03:12:16 pm »
Hi,

Expand the regular dimension in the structure tree on the left. Select your Yearweek attribute, and in the Properties window at the bottom, scroll down and find the Prompt Info property. Expand this, and change the Prompt Type from "Server Determined" to "Select Value". Hopefully this will force a value prompt instead of a type-in prompt.

Regards,

MF.
Meep!

Offline TheDarkKnight

  • Full Member
  • ***
  • Join Date: Jan 2010
  • Posts: 34
  • Forum Citizenship: +0/-0
Re: Filter values
« Reply #2 on: 17 Jun 2013 04:09:35 am »
Perfect!..it worked.. Thanks MF.