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

Issues with parameters

Started by mbrassfi, 25 Jan 2010 10:34:58 AM

Previous topic - Next topic

mbrassfi

This is probably pretty novice, but im having an issue making a parameter.  I will try to explain the situation as best as possible.  I work in non profit, there are 3 fund type 2's - 10, 20 and 30.  I want all funds within fund type 1 = 10 and fund type 1 = 20, but I only want fund Level 2 = 300000 from fund type 1 = 30. Below is a visual representation of the hierarchy. Please let me know what I can use to do this. Thanks!

Fund type 1 | Fund Type 2 | Fund Level 1 | Fund Level 2

10               
                    11   
                                        100000   
                                                             100000
                                                             100001
                                                             100002
                                         150000
                                                              150001
                    12
                                         ...
20
                     ...
30         
                   31
                                     300000
                                                             300000

MFGF

Hi,

Is this a filter?

[Fund Type 1] in (10,20) OR [Fund Level 1] = 300000

Does this give you the correct data returned?

Is this a dimensional or relational package by the way (ie do you see dimensions and hierarchies or Query Subjects and Query Items)?

MF.
Meep!

mbrassfi

Ah, I was way over thinking it.  That works.  Thanks