Erin Trotter

It seems that the pattern with it working or not working has to do with whether or not you just accept the default sources for the parameters or if you decide to change the source of the parameters to something else (in the instance that you want to display a description to the user to choose from rather than a code. when you do this, it breaks the chain and the parameters are only chained to the one directly after it and no further than that even though everything is set up correctly.

Sorry, I've been in training all week, but I'm glad you found my tip helpful! -Erin

I have something similar on a report I've done. I created a defined field based off of the text in a column using HTML code:

Well, instead of going the CAR file route, I added the parameters in the actual fex that is displayed on the dashboard using the "WITHIN" keyword in addition to chaining them in the dashboard. Now they work correctly. It is just strange how sometimes that works without doing the WITHIN and other times it doesn't. I was using a reporting object at first in the fex, so I thought maybe that was the case, but I have another dashboard using a reporting object and it works just fine.

So the strange thing is that this works on one of my dashboards, but not on the other. Neither of my synonyms have hierarchy in them either. The parameters are indented just like yours but, for your example, if I changed Author Language and skipped over country, it would show all authors as if I never filtered the Author language. I will see if I can replicate it with the car file

Thank you @Dave Pfeiffer!

I have a visualization page that I've created in 9.1.1 that has several parameters that I have chained together. For example Department -> Division -> SubDivision However, when I select a department, it does filter the division, but it does NOT filter the subdivision. I have to filter division otherwise, subdivision shows ALL subdivisions even though they don't exist under the Department. The way I chained them was by dropping the child filter on top of the parent and it looks correct visually (indented as it goes down the list) in the filters section. Is there something else that I need to do to make these controls filter even if the user decides they want to jump straight from Department to Subdivision? Or is it possible?

Thanks John! I was also able to connect and get the data. This helps a bunch!

We need to be able to check a user's last login into the system and disable any user accounts that have not logged in for the past 90 days, but we need to automate this process, so we need a way to get the list of users and their last logon date/time. The resource analyzer does not seem to have a way to schedule something like this and seems to only be on demand.

Thank you!!! You're the BEST!!

Thank you. I will re-check my code. Maybe the 'H' was throwing it off.

Good morning, I am creating a visual page. One of the visualizations that I'm adding to the page is a report that has a hyperlink in each record that brings us to html content (created within app studio). I want to be able to click the link in the report and have the content that applies to that line of the report open in another panel on the same visual page. Interactions doesn't seem to work (or I don't know how to make it work) because you open something by clicking the panel itself and not the specific line of the report in the panel. Is there a way with Javascript to accomplish this? I'm using WebFocus 9.1.1

Is it possible to set a default value in a reporting object. I'm using WebFocus version 9.1.1. I have some reports that I needed to load while I have the parameter panel in the background still processing. I set the parameters in the reporting object as optional, but one in particular (year) I guess defaults to all in the reporting object when not selected. I would like to default it to the latest year so that if a user clicks a report while the parameter panel is still loading, it does not pull in 5 years of data. We don't even want to display this much data temporarily. I tried to add -DEFAULTH &YEAR = '2024' in the preprocessing part. It doesn't do anything. I also have had no luck on finding any documentation on how this might be possible or much documentation on the reporting object at all beyond the basics of it

FYI... I found a workaround. I created a link in the app folder that linked to my visualization and then I add the link as a URL request. Instead of adding all of the parameters that automatically show up in there like BIP_folder, etc, I created hidden parameters on the HTML page for each of those and put a static value. That way when it passed them along with the regular parameters, there was only 1 "?" in the query string instead of 2.

Ok. thank you