nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Row-wise initialization

mlov83

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!

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

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

mlov83

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.

Joel Acha

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.

mlov83

Joel,

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

[Deleted User]

How can it not be set?

Upon login the query has to run.

mlov83

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.

Michael Verzijl

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?

[Deleted User]

+1 to Michael. More info needed

Andrew Fomin.

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.

mlov83

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.