Date Type Parameter as Presentation Variable in Fusion OTBI Reports?
HI Friends,
Any idea how can we get the above requirement ?
Hi friends,
Any pointers?
Thanks
Ashish
Ashish, Try this...http://appsconnect.custhelp.com/posts/bc917dca50
Hi Julian,
This gives me the current system date on the Prompt, but can we have a date picker.
Also i had a chance to look at the Service Anniversary Summary and Detail Report and couple of questions i have are :
a) Why does the report says an error when we click on Results tab (adjacent to Criteria) it works fine when ran from Catalog though.
b) Can we use this Data Picker Prompt and compare some other fields say
Last_update_date > EffectiveDate.
Expecting your co-operation as always
Ashish,
I don't think you can have a date picker.
a) This is the expected result when you have a report prompt.
b) I'm not sure what you mean, but I think the answer is yes you can. Have you tried this?
So how do we ensure that user picks the correct format. User in differen countries would have different way of looking at Date formats and if they enter a incorrect value it would error.
Is there a feature we can have something like 'Enter Date in YYYY-MM-DD' on that field (Grayed Out).
Regarding the second point last time i tried I could not get the Presentation Variable referenced in the filter Criteria.
Meanwhile if you get something handy please feel free to pass it on
You can add the required date format as part of the prompt label.
Does this help for your second point: https://community.oracle.com/thread/2333955
There is plenty of help out there, I just searched for "obiee using presentation variable in filter" and the above was my first hit.
I raised an SR and the support team gave a workaround. I have made a document out of it and sharing this across for the benefit of other community members.
Hi Ashish,
I have gone through the document . It is very helpful and working fine.
I need one more requirement like, how can we add a presentation variable quarterly parameter like; 2017-Q1, 2017-Q2, 2017-Q3, 2017Q4 like for each year .
Thanks,
Murali
You should be able to derive this based on current date
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
