Here's a screen print showing the issue I am facing. Thanks, Dennis

A co-worker did some research on Oracle Support earlier. He found an article, Oracle Support Note 2272915.1. It describes the issue we are having. The article refers to a patch that can be applied: 25353706. It says that this fix is included in version 12.2.1.3.0. Like Rizwan, we are on version 12.2.1.2.0. We have not yet…

Thanks Rizwan and Robert. It's good to know that we're not the only ones experiencing this issue. I was starting to think we were just missing something obvious. I'm intrigued by the idea of using a formula to generate the URL. How would that work? Would I create a new column whose formula results in the entire URL? And…

Hello, After a month, I am finally getting back to this. Thought I'd add more information to see if that helps clarify the issue I am having. On the criteria tab, I navigate to the hierarchy column. I select Column Properties and click the Interaction Tab. Primary Action is: Drill + Action Link The URL is:…

Did you mean to say "Fact -> A -> B in the logical"? This could be just my ignorance showing again, but we don't have any fact tables in the physical layer. So far, we've only seen fact table at the logical layers. Anyway, if you did mean "logical", we did have (Fact -> A -> B) originally. However, as we continue our trial…

I'll try to answer this as best I can. Table "A" is a dimension table. Table "B" appears to be a dimension table as well (given there is no # symbol next to it), It contains additional information that we want to look up through the ID field. I am still wrestling with some of these basic concepts such as dimension and fact…

Hi. Thanks for your replies. By "clone", I simply meant that we have another table very similar to the one I am trying to create. Among other things, the new one contains a hierarchy similar to the one that already exists. It is not a copy in the "drag and drop" sense; it's more of a copy in the sense that I tried to…

Thanks, but that link is for a 2 hour course on building analyses and dashboards. I have some background in that already, but this is the first time I have encountered this particular problem. If I mark the parameters (in this case they are column values) as fixed and hidden, then they do not get passed to the second level…

Thanks! " RANK(ticket_number BY employee_id) = 1 " works perfectly. I appreciate the tip. Thanks everyone.

Thanks! I didn't even know that option was available. I gave that a try. But it looks like it's only printing the filters on the analysis. I think our users are hoping to print the dashboard prompts as well. My guess is that since our prompts are on the dashboard level, that printing the analysis by itself would not know…

Haha.. Ok. That's what I saw when I clicked on Help. Not sure how or where I find the precise version number. I still have much to learn about OBIEE. Anyway, I stumbled across something that fixed my immediate issue. When clearing the cache, I saw a checkbox at the top that says "Preserve favorites website data". That box…

Thanks. I tried your suggestions, but I'm still seeing the same issue. Here are some more specifics: Internet Explorer version: 11.1106.10586.0 OBIEE: 11g Release 1 (11.1.1) And I made one additional observation this morning. The prompts work great for me in our production environment (same versions of everything). It's…

Thanks Joel, It took some doing, but I followed your suggestion (using column properties instead of the action link) and it worked. I haven't tried the other suggestion that was made, but if time allows, I will try the case statement solution also. Thanks to you both! Dennis

Here's a screen print of what I have so far. Just for clarification -- this is for an Action Link object on a Dashboard Page. It is not an interaction with a column on an analysis. The action is to "Invoke a Brower Script". I now have two of these scripts - only one of which can be invoked depending on the value of "Status…

Hi. I've done this before on an Interaction tab of Column Properties, but the Action Link object itself looks a little different. Is there a way to do this directly on Action Links? Thanks! Dennis

Rumor in the office is that I don't (and can't?) have access to Catalog Manager. Not sure I understand that but I will keep working on it. As a developer, it would be nice to be able to use that to help document our code. Also, in response to Gianni's last reply - When I navigate to my customization in the Catalog (through…

I want to provide a quick follow-up on this. We noticed we had the same issue in Dev. The BI server variable containing the query we are using to populate the default value was not working correctly. After we redeployed the RPD file, the query started working again. While this is good news, it sounds like a spin-off of the…

Hi Christian, I'm not familiar with either D3js or Oracle JET. Are those separate products? Are they included with the standard OBIEE suite? Looking into our current system, I notice something else. My predecessors on this project were able to accomplish exactly what I am describing. Unfortunately they are not available…

Thanks! Now all I need to know is the User and Password. I'll do some more digging around the office. Thanks again. Dennis

I met with a co-worker this morning for a couple of hours. We finally figured this out. While we had the action links correctly set up on the measure fields (the various dollar amounts), we learned that we had to include the action link on the status code field as well. There were three conditional action links on the…