Fiscal year vs Calendar Year in BAQs/Dashboards

Yahoo Archive
1
Just a follow up to this....the BAQ designer does have built-in functions for calculated fields called FiscalYear and FiscalPeriod, that you apply to whatever date field you want to convert.  They reference the Fiscal Calendar that exists for the company in question. 

They work, but they noticeably slow down the BAQ execution.  

BTW, the UD table idea worked, but it also slowed the BAQ...probably more so than the FiscalYear and FiscalPeriod built in conversions. 
2

How do you guys convert "Calendar" dates back to your Fiscal Calendar dates in BAQ's / Dashboards?  For example, I want to create a Dashboard where the user would enter/select Fiscal Year and Period.  Let's say they enter 2014, fiscal period 1.  How would you then take that and convert it back to transactional dates that would be in the specific tables to retrieve results? 


I thought about using a UD table that would have Calendar Dates is one field and corresponding Fiscal Year and Period in two other fields. I would create a join from the transactional table to the UD table and make the prompt on the Fiscal Year / Periods in order to pull the Calendar dates.  It would certainly work, but I'm looking for a cleaner way to do it.