Jump to content

CASE OPENED**Anyone run into an issue with changing the Canvas Data Limit (Live/Test) in Designer?

Debra Waybright
Go to solution Solved by Debra Waybright,

Recommended Posts

I had a user complaining that his visualization won't give him correct answers. I ran it and got the correct results so I was puzzled. The only thing I can figure is that he changed the Canvas Data Limit setting when he was editing the chart in Designer. I ran a test, creating a similar chart. I ran it without changing the limit and it runs correctly, but after I change the setting, even once I've left the Designer editor and am running from the Hub, I still get the limited data. Logging out of WebFocus doesn't seem to fix it.

I had him try setting the Limit to match what the system default is. No luck. I had him try setting it to "Live" and "All". Still no luck. It is like if you touch that, it sets it to "Test" "50" forever 😨

Link to comment
Share on other sites

@Debra Waybright​ 

Have you tried to verify if the user is able to query the same data from outside of WebFOCUS (querying the table directly using TOAD/ DB Visualizer) to confirm he is able to get the correct numbers? Most likely his access to the database needs to be checked as well.

Link to comment
Share on other sites

  • Solution

Good thought but that's not the issue. We think we've narrowed it down to not the canvas limit, but where the report filters were added -- he added them in the SQL in the Data tab. When someone else created the same report but put the filters in the Visualization tab, the report works for everyone, including him. It is just really odd that putting them in the Data tab broke it only for him (I could run that report and it worked fine).

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...