I need to make a prompt in my universe .The requirements are:
User inputs a month and a year in the prompt.
Now the data from the financial year month starting to the month the user has queried should be displayed.
Financial year starts september every year and ends in August.
So if user selects June 2007 then the data from September 2006 till June 2007 should be displayed.
How can this be achieved?
i don’t have the financial year calendar in the database.
underlying database is MS SQL Server.
Using BO XI R2
Very brief:
Create a smart calendar table with columns such as:
Calendar Year, Calendar Month, Calendar Quarter,
Fiscal Year, Fiscal Month, Fiscal Quarter,
Period Nbr, Prevoius Period Nbr, etc.
Join this smart calendar table to your fact table accordingly. Create universe objects off this smart calendar table, create predefined conditions as required.
cant i do it without creating the fiscal year etc… i 've calendar year, month etc.
An idea to do this :
Take the user month n year… if prompt(month) in (1,2,3,4,5,6,7, 8 ) then display the data from September of (prompt(year)-1) till prompt value
else display the data from September of (prompt(year)) till prompt value
is it feasible to usse it in code somehow?
I new to BO Universe.
why you don’t want to create fis_year object in universe. It will not alter your database structure. It can be done without creating fis_year object but for that you need to apply fis_year object logic on every report, so better create a object in universe.
(BOB member since 2009-08-06)
(BOB member since 2002-06-20)