Global Filter Usage

[vamsivanka]

Its a tricky question to ask, but i will try my best to show in the Image.

I have two drop down in the Prompts page, and the First one have options of Project, Org, ReOrg, etc., and based on the first selection the second cascading drop down fills up,

Query Column formula (Also, please see Image1.png)

case ?pTopGroup?
when 'PROJ' then [PSR].[Projects].[Project ID Name Level]
when 'R' then [Project Summary Report Final Data Reporting].[Reorganization Structures – Owning].[Reorg ID Name Level]
when 'ORGP' then [Project Summary Report Final Data Reporting].[Organization - Performing].[Organization ID Name Level]
when 'ORGO' then [PSR].[Organization - Owning].[Organization ID Name Level]
when 'PROJA' then [PSR].[Project Report Project].[Project Report ID Desc Level]
when 'PM' then [PSR].[Projects].[Project Manager Name]
when 'CUST' then ([PSR].[Projects].[Customer ID] + ' ' + [PSR].[Projects].[Customer Name])
else ('')
end



In the same query (see image) there is also "Detail Filters" and in the i am using the Global filter, see below..

case ?pTopGroup?
when 'PROJ' then [Costpoint].[Project Level Filter]
when 'R' then [Costpoint].[Owning Reorg Level Filter]
when 'ORGP' then [Costpoint].[Performing Org Level Filter]
when 'ORGO' then [Costpoint].[Owning Org Level Filter]
when 'PROJA' then [Costpoint].[Project Report Level Filter]
else (1=1)
end


Not sure, why i even need to use this Global Filter. could you anyone explain this ?