FYTD in Dynamic Select

Stephen Kirk

The Idea.

To allow a FYTD to date option in a dynamic select.

 

Why.

Currently a dynamic select allows the user to be able to select the YTD based on a cube or the current date.

For financial reporting purposes, I believe a FYTD would be more useful so having this option would be nice.

 

Current process.

Using a series of dataflows to populate a cube indicating the FYTD and making a select based on this cube.