Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Row-wise initialization
I have set up a row wise initialization block and I have assigned it to a non system variable in BIEE 12c. When I tested it locally, - when I push the "test" while working on the rpd - it works. But once I publish the rpd back to the server, it does not appear to be retrieving the set of values that I would expect. I added the Row-wise variable to a filter and it does not seem to be working at all. I'm not sure where to look anymore. Can anyone please offer any suggestions. Is there a limitation of the rowise variable? I know I expect about 7k rows returned.
Thank you!
Answers
-
a) HAve you checked the log files for the actual query being emitted?
b) 7k? That's probably something you'd rather want to bake into the model
0 -
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 would be a table that would would user values different for every user. That is the reasoning why I have gone down this path.
0 -
Hi @mlov83
as @Christian Berg asked, have you pulled out the query from the nqquery.log file? That would be the first place to look and determine if the BI Server is generating the right SQL. If not, it could be an issue with your rpd model.
0 -
Joel,
Yes, and unfortunately the variable is not getting set to anything.
0 -
How can it not be set?
Upon login the query has to run.
0 -
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.
0 -
You are sure that the RPD is uploaded correctly? Did you download it and see the code for the init block?
Could you share what you are trying to execute in the init block?
0 -
+1 to Michael. More info needed
0 -
1. AFAIR when init block fails info about it is written into nqserver.log, not nqquery.log.
2. What database do you use? After resolving this variable issue you may encounter a new one: limitation for a number of elements in "in" operator. For Oracle DB the limit is 1K and that is significantly lower than your 7K.
0 -
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 function would be a better solution to my problem since what I was trying to accomplish is essentially only show the users the values that are related to him or her. I didn't find the NQSERVER log, but I guess I'm just not looking in the correct location.
Thank you all for all your help.
0
