Thanks for the reply Christian. One small caveat that I fail to mention is that when I set the amount at the highest level it properly gives me the total amount of the invoice, So I guess what I really need to do is something like a calculated field in the rpd that would so something like "sum(invoice_amount by Invoice)".…

I mean like so https://docs.oracle.com/en/cloud/paas/bi-cloud/bilug/manipulate-members-groups-and-calculated-items.html#GUID-26068C5E-DE1D-42DA-801E-2653B67BEB9A. I go to one of the analysis and based on a columns code I create a member group based on those codes. The exact version is Oracle Business Intelligence Product…

Thanks Gianni Ceresa , That is very helpful! I'm much closer to the results I'm looking for, however, is there anyway that I can use something substring or something similar to get the first two characters of every string while using the "in" clause. I really appreciate your help. This is very helpful!

yes I can. I can tsnping db no problem. i would really love to know what the OCIEnvNIS is calling? It Leads me to believe that It expects some dll somewhere else.

yes, that's no problem. My issue has to do with the on the local machine which is trying to connect to the database, I have the oracle prepared virtual machine with obiee already installed in it and it can connect to the the specific DB's. RPD tool is just giving me a hard time.

Joel, Thanks for response. But this is simply setting the connection to the server the has the tables for my RPD, which is not necessarily the OBIEE server. However, yes I can connect to obiee server with sql plus. Thanks. Miguel

Just for the record in case someone else runs into this issue. You can download a md5 checksum tool for windows https://www.microsoft.com/en-us/download/details.aspx?id=11533 . once downloaded read the readme file and run but basically the command is this. fciv.exe SampleAppv607p-appliance.zip.001 it will print an md5 hash…

I think I have finally figured out what was the issue. For starters I was using a "With" clause within my row-wise variable. That seemed to not work appropriately. Secondly I had 7k+ records in my list of return values and the in clause as mentioned by Andrew Fomin would be able to handle it. I'm now looking to see if a…

Thats whats confusing to me . It appears like the query is not running upon loggin, yet if i hit the test query in the RPD i get an ouput in return. 2 days now trying to do something simple :-D.

Joel, Yes, and unfortunately the variable is not getting set to anything.

Christian, I have logging set to 5 on my rpd. I than run a report in which I'm using the variable as a filter on a report, and it does not appear like the value is being set at all - that's my issue. However, I'm not sure that I'm doing this correctly. I though about setting at the model but the problem here is that this…

Thanks Andrew for the response. I'll give this a good read. I was trying to do a little testing with roles and conceptually understand how these pieces fit together.

year is one of the column along with the other columns I mentioned previously. I would like to identify the max year per row and than sum the amount column for that row. Thanks again.

Fair enough Christian, The basic step here, is that I'm trying to get the max year for every rnl.rnl_fund_code rnl.rnl_orgn_code rnl.rnl_acct_code rnl.rnl_prog_code rnl.rnl_actv_code as one row and than I would like to sum those rows. In its most basic form that is all I'm trying to accomplish. My apologies with the code I…

YES. That's the sub query part I'm stuck with. I want to be able to get the max year. I'm basically joining two table alias but from there I'm stuck.

Thanks Christian, I completely understand that OBIEE does not work in this fashion, however, would you help me understand how I might accomplish something of this nature in an OBIEE model? Thanks! 

Thank you guys. Now that makes much more sense! I really appreciate the respond.@rmoff, great article. I can't believe I did not run into this one. Thanks a bunch!

Thanks Christian, Now It makes sense. I really appreciate your time in answering these noob questions.

Gianni,Christian Thanks for response. I'm completely new to OBIEE and I'm still trying to understand how things work. I apologize I was not very clear in asking my question. I don't want to have all the developers use their user name and passwords while working on their projects. My question to you guys is, if I have…

Fair enough I guess I will start over with a 2012 install. Thanks for the response everyone.