Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Group Filter set to parameters with default values but no data returns, even though it's there.

Accepted answer
33
Views
9
Comments
Rank 3 - Community Apprentice

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?

Welcome!

It looks like you're new here. Sign in or register to get started.

Best Answer

Answers

  • Rank 8 - Analytics Strategist

    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.

  • Rank 3 - Community Apprentice

    The data source is an excel spreadsheet. How would I edit that query?

  • Rank 6 - Analytics Lead

    Leave the filter out.

    Just create a data set with the xls spread sheet.

    Does it generate data?

    Kevin

  • Rank 3 - Community Apprentice

    Without the filter, data generates. I constructed it with no filters at first.

  • Rank 3 - Community Apprentice
    edited Apr 8, 2025 1:32PM

    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.

  • Rank 6 - Analytics Lead

    Please log an SR to get direct assistance.

    Rgds,

    Kevin

  • Rank 3 - Community Apprentice

    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.

  • Rank 6 - Analytics Lead

    That's great, thanks for letting us know.

    Rgds,

    Kevin

Welcome!

It looks like you're new here. Sign in or register to get started.