How to constrain fiscal period based on fiscal year in BI 11g prompts?

Question

Hi ,

i am working on OBIEE 11g  . I have requirement to constrain fiscal period based on fiscal year . i was able to constrain all the fiscal year based on previous prompts because those were on different presentation tables but fiscal year and fiscal period are on same presentation table .

SriniVEERAVALLI · Answer

Use SQL for that prompt to include specific metric in where clause like

select fiscalPeriod from TimeDim WHERE Metric>0

3136676 · Answer

I tried that it filters fiscal period only until current fiscal year. i want fiscal period to be displayed for which there is data . Like if FY 2014 and Fiscal Period : 1 doesn't have data i don't want to display that fiscal period in my prompt.

Gianni Ceresa · Answer

Hi,

Can't you just enable "Limit values by" and let OBIEE care about it? If the both come from the same table (you say presentation but I guess it's also the same logical table) OBIEE will filter the list of fiscal periods based on the value selected in the fiscal year prompt.