I created a Data Model with an Excel spreadsheet. I added a group filter setting the parameter to a value and I even converted it all to strings in the group filter. However, I'm still not getting any results back. What could be the issue here?
Try adding a parameter to your data model instead of a group filter.
https://docs.oracle.com/en/cloud/paas/analytics-cloud/tutorial-create-data-model/
Rgds,
Kevin
Hi @jmore92,
Quick question: Have you executed the query with all the parameters values directly from the data model editor to see if it is fetching any results? If it is bringing data then we have to check while passing values from prompt there might be some issue.
If you can share some screenshot (without any sensitive data etc.), code etc. it'll be helpful to understand the issue.
Thank you.
The data source is an excel spreadsheet. How would I edit that query?
Leave the filter out.
Just create a data set with the xls spread sheet.
Does it generate data?
Without the filter, data generates. I constructed it with no filters at first.
I tried adding the parameters to the data model setting the columns to th parameter values but I'm still getting nothing back. I removed the group filter, too.
Please log an SR to get direct assistance.
I got the parameters to work. It turns out on one of them there was a data issue in the spreadsheet causing it to not work.
That's great, thanks for letting us know.
I created a XLSX template in Oracle Analytics Publisher Desktop 26.01.01 and uploaded the template to a BI Publisher report in OTBI. Things worked initially, but this morning when running the report I received an error: The report cannot be rendered because of an error, please contact the administrator. Error Detail:…
Hi All, I have a question regarding the BI Publisher Outputs. I have configured the rtf template output as Excel but when the XML Report Publisher program completes and I click on View Output, the output opens in a browser and renders as an HTML. Can some one please assist why this is so. The BI Publisher version is…
The issue is related to the NordPass browser extension installed via our corporate policy. Issue observed: Users were unable to upload custom BI Publisher templates in Oracle Fusion (BI Publisher / Oracle Analytics) using Microsoft Edge and Google Chrome. The upload dialog remained indefinitely at "Uploading, please…
Hi, We are scheduling a report to be sent out every week. We were wondering if it was possible to keep the latest date that the report ran as a parameter somewhere so that we could use that to only fetch the values in the report which have a latest update time of after the last run of the report? This way we'd only be…
