on 08-14-2015 7:10 AM
what front end / client tool are you using?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If dates are available in the report for one year.(At least one date for each month) then use like this.
Var==FormatDate([Calendar Date];"Mmm-yyyy")
If data is more then one year in the report then along with above Var create one more variable.
Var1==Rank([month];Top)
Apply Block filter on Var1 between 1 to 12.
Amit
We are using SAP BO4.0
Below is my issue:
User will select end date from that date(current date) to previous 12 months data in month wise
Example user selected 28-02-2015 then i want previous 12 months date from user selected date
FEB-2015--JAN2015--DEC-2014-NOV2015------MAR-2014
***Note: their is no start date. user will answer only end date.
Please help me any one.
Hi,
In this case you need to add the Pre defined condition in the Universe to fetch the 12 months data based on the user input date.
If your back end is BW then you need to do changes in the BEx query filter to etch the 12 months data based on the user input date..
Other option is User always enter from and to date in the prompt.
Better to do in the universe or if backend is BW then can do in the BEx query.
Amit
Hi,
Once you get the 12 months data and if you have Month/Year object available in the webi report then simply drag the Month/Year object in the report.
Other way drag the date filed in the webi query on which you have created universe condition and create one variable.
Var==FormatDate([Date];"Mmm-yyyy")
With this also you can display Month & year in the report.
Amit
Hi,
In this case add one more query in the Webi query and only drag Period date and keep the same Prompt filter.
After that Merge both Period date from Query 1 & 2 and create variable on the Merged Period date only.See if it will work.
Or if you have some calendar date object in the universe from you will get all dates then use that particular object in the second query.
Amit
Hi
i tried Query1&2 with same period date it is not working. how ever i will try next option.
and period data date are not coming in order see below.
in my scenario
if i select 31-Dec-14 i want to see header like below.
Jan-14--Feb-14------------------Dec-14 like in order. it should be Dynamic.
Thanks,
S Surya Teja.
Hi,
For sorting by month and year follow below steps.
Create variable Month=FormatDate([Period date];"Mmm")
Year=FormatDate([Period date];"yyyy")
Place these two variables above the Month-Year variable.
Right click on the Month->Sort->Advance->Custom Order->Values and select the Months order.
After this apply the Ascending order on the Year variable.
Check format is coming correct or not.
Right click on the Month variable and Hide it.Same for year Hide it.
Regards,
Amit
Hi
Create 2 user defined object at universe level using the following syntax
FIRST_DAY(TRUNC(ADD_MONTHS(SYSDATE,-12),'Month')) - return 1st day of previous 12 months
and
TRUNC(SYSDATE) - Returns current date
Then at the query panel level drag the date object in to query filter make the condition is
Date between TRUNC(SYSDATE) <= and
FIRST_DAY(TRUNC(ADD_MONTHS(SYSDATE,-12),'Month')) >=
Try this you will get the previous 12 months data.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.