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
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
