Focal Point
OLAP - Filters not listing the values

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4721025312

February 16, 2007, 10:22 AM
Usernani
OLAP - Filters not listing the values
I am working on OLAP report and I want to show filters on top. but the filters just list All and do not list other values.

How can I get the values on filters?

Thanks,
February 23, 2007, 11:55 AM
Kerry
Hi Usernani,

Has this issue been resolved?

I am wondering, which release of WebFOCUS are you currently using? I ran a bit search on Information Builders' online documents and came across the following topics which may be of interest:

OLAPBig Grinropdown not listing values with special characters

OLAP: dropdown displayed in wrong place with many filters

You will need to have an InfoResponse username/password to access these documents.

Hope this helps. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
February 23, 2007, 04:50 PM
slfmr
I found that sometimes you need to make sure the formats in your master files are working with you.

I found the AnV format doesn't work so you can change that in your master file to just an An or you can do it in a define:

DEFINE FILE MYFILE
NEWFIELD/An = OLDVFIELD;
END

That helps to populate the parameter lists at the top.

SLFMR


Dev, SIT, UAT, Production:7.6.6
Dev Sandbox:7.6.11

Dev Studio - 7.6.6
February 26, 2007, 09:18 AM
Usernani
yes, I have figured out that. I notice that when I do not have any parameter then the filters list the values but if I have some parameters then the filters do not list the values. Please let me know if I have have to do any thing.