This is interesting. Thanks for sharing. Did you set it under Special format? I couldn't see CEP code as a value on my excel? If possible please share a screen shot. Regards.

Hi Sandeep, As this is a query not an idea, you should have posted it under discussions. I would request you to close this idea and post it under appropriate category for proper traction. Thanks.

Upvoted.

This should be delivered. Upvoted !!

Are you not able to handle this at query level? Thanks.

Is this not working? Please share some scenarios where this is not working. Thanks.

Is this on fusion SaaS or standalone BIP you are talking about? Also, share details on current format of your key. Thanks.

Hi @Swapna Govind , Were you able to resolve this? Thanks.

Can't you print the parameters as data model attributes and then use them as conditions in your eText template? Thanks.

Upvoted. Great idea .

Looks like you are using a demo instance. Are you able to confirm if you are able to see the details from application UI? Thanks.

Can you please provide more information on your query? What modules this is related to and any screen shots from application UI that can help the community to better answer your query. Thanks.

I think this is happening because data is not getting refreshed post WR cancellation as the assignment records are deleted: Frequently Asked Questions @Ravi Guddanti-Oracle , Do you have some inputs here, please? Fusion HCM Analytics - Frequently Asked Questions — Oracle Analytics Thanks.

Upvoted !!!!

I haven't seen this anywhere. Would be interesting to get the SQL behind this view. But I assume this will be a restricted object and may not be available publicly. Hi @Raghavendra Raghunath-Oracle , Hope you are doing well, Can you please help if it is possible to get the query behind BIPUBLISHER_V? Thanks.

It should work right. It will display the data only for entered DFF based on expense type other one will be blank. Can you give it a try once? Thanks.

Hi Marc, Just trying to understand your requirement a bit more in details. You have different reports or only a single report that sends data 50 times per day to a single SFTP? or is this not the case? can you please elaborate a bit more? Thanks.

I don't think there is a way to generate this list in BIP. But you can check the data lineage sheet available on below thread: HCM OTBI subject areas to database lineage mapping spreadsheet — Cloud Customer Connect Thanks.

Below should help: Bi Publisher - add x days to a date element in rtf template — Oracle Analytics Thanks.

You can use concat to achieve this. Check an example on below: How create a column by concatenating multiple columns in otbi — Cloud Customer Connect Thanks.