I am having the same issue. It seems pretty clearly a bug, which I will report through an SR. Steps to reproduce (tested on two different running instances, both 12.2.1.4.190416): 1) Create a new Agent (content, schedule, recipients set as you wish; it does not affect the issue) 2) From the web catalog, edit the…

Hello Farrukh, As Christian says, colors are assigned at run-time (sort of, see below) and without intervention by the analysis builder they could change if, for example, filters or prompts change the list of Channels that might appear in the graph. IF your list of Channels is fixed and IF you always sort them by their…

Alright thanks. I'm very familiar with the Dev Tools; I have solved other problems using the method you describe. I was more wondering, for example, with the CatalogTreeModel call for saw.dll - this is not Javascript, correct? This is something buried in the bi binaries. So by using the Dev Tools I can see that…

Yes, if I use that string it does come up. I was approaching my search more from the standpoint of "hey this BAR file migration didn't work" so my terms weren't quite right. Where does one go to learn, for example, all of the parameters available for the CatalogTreeModel call? I can tell what it is doing in your script,…

Downloaded and installed the .catalog file for the Agent Manager page. It's capital-A Awesome. Thanks. I'm going to put in a "Disable" button and then play with adding a filter to the list for our business units - show me only Finance agents, only M&S agents, and so on. (ETA 20 minutes after writing that: eesh, I am a…

Alright thanks. I will read your writeups Gianni. We thought about ways to script/automate the re-registering of Agents, which would at least save us some time. We have done the "clean/recommended" way before manually - 3 developers working for basically an entire day to go click on every agent in the system. Not fun. And…

Hello, Are you interested only in knowing the rowcount, or do you need it displayed in the report? There are ways to do both. Knowing the rowcount * If you are an administrator (or if your admin grants you appropriate rights) you can see rowcounts in the session log, available from the Administration screen in the web…

Answering my own post, as this is just for information for future searchers.

Christian, to what are you referring when you mention "folder permissions"? Are you talking about presentation layer table & columns? As seems to be Oracle standard, the documentation (including KB notes) is scattered and contradictory. At this point, I am not 100% sure about: A) Can I still use @1 notation for positional…

Final comment for anybody who happens upon this thread later: This is a KNOWN BUG and there is a patch available for 12.2.1.2 (but not, as I understand it, for previous versions). Look for "Patch 25887247: TRACKING BUG FOR DATADIRECT 8.0.1 ODBC DRIVER MANAGER". Bug # is 25887247 however this does not appear to be publicly…

Oracle support's determination: "Hmm...that's strange." I was very impressed that we skipped past all of the usual "do A, then B, then C" stuff - stuff which we've already eliminated as a cause - and got right down to a demo of the issue. One of my best Oracle Support experiences so far. The rep clearly understands what…

Yeah, well it's weird. It definitely replaces the webcat and the jazn. Just the RPD is left alone. Not even "merged", I'd say. At least, it didn't add any Sample App subject area(s) into it. Just my little baby test model was in there. To use datamodel, I'd need just the RPD from the SampleApp BAR file, right? I'll Google…

Thanks for the suggestion, Matt, but it's not "a" column. Which column will show up as empty changes depending on how I change the request, and a column which was blank before might show data if I change the request slightly. The first post has the details.

So, sort of related because I'm trying to get SampleApp working - when I import the BAR file, everything seems to work, but the RPD is not updated. The command I am running in WLST is:…

As someone who once had to do coding in BASIC or COBOL, I find it difficult to number anything in sequential integers. Even my logical table source priority groups are 10, 20, 30, etc. You just never know when you're going to need 15 in there.

Thanks again both of you for helping work through this. Our product manager just finished a fresh migration of our 11g production RPD/Webcat/Jazn to a different 12c environment (still RedHat) and I tested that installation with the same results - random this or that column is blank. The subject areas I'm using to test are…

Just out of curiosity: Have you already run a vanilla RPD on that server to see whether you get the same beahviour? Well, the RPD was created using File -> New Repository from the 12c Admin tool. I then uploaded that RPD (after much difficulty getting the upload to work due to my own stupidity) and created my test model in…

Our 12c is on Red Hat 6.8. 11g is on Windows so we're changing OS along with the upgrade. To keep things simple, you see. <rolleyes> (not my decision) I tested the logical SQL using a direct ODBC tool. The empty column comes back "" (empty string) in the raw results. So, that's significant. I tried comparing byte count,…

I haven't tried a direct ODBC connection yet; I will try to set that up. I'm also going to play with degenerate dimension columns vs. normal, and calculated columns vs straight mappings. We did have one other 12c instance up and running; I'll talk to our product manager about getting access to that for a quick test. Ebin:…

For a given analysis - that is, the same combination of dimensions and measures on the Criteria tab, ordering is not important and neither is filtering - the same column will always be blank. Whether run directly in Answers, or via the "Open" link in the webcat, or embedded on a dashboard. If I add a column to the…