Recent content by jaburke

I have a javascript variable defined as: var name; In my HTML, I am calling a javascript function that sets the name variable. Once I return from the function call, the value of name isn't set. What am I doing wrong? How can I access the value of the name variable from the html after the...

I tried it and I get a "bad substitution" error.

Hi, I am having to rewrite a script from dtksh to ksh. I had something in the dtksh that looks like this: if [[ $countit = 3 ]] then var1=${line:0:10} var2=${line:11:29} var3=${line:42:1} fi This syntax for the line parsing doesn't translate to ksh...

No, I'm building a webi report off a universe and that's where I've created my object. I finally got this to work with a small tweak to my formula above. I changed it to this: DECODE( TRANSLATE(@Select(Class\Field),'_.0123456789',' '), NULL, 'number','char') I added a decimal after the...

Hi, In a universe object, I am trying to convert a string to a number if it's all numeric. This is working fine - almost all of the time - using this formula: DECODE( TRANSLATE(@Select(Class\Field),'_0123456789',' '), NULL, 'number','char') So I am converting to 'number' or 'char'. If it...

Hi, Is there a way, in webi, to suppress values when they are duplicated on multiple rows? For example, if I have a report that shows store and I have three rows that say "ABC Store", can I somehow suppress the value on rows 2 and 3? Thanks.

I have tried 1 and 2, but I will give 3 a shot. Thanks!!

This is the only parameterized report I'm having a problem with. I have hundreds that are working correctly.

I'm scheduling through InfoView. BOE 3.1.

I have a crystal report that runs fine when it's run on demand, i.e. viewed. When it is scheduled - something is going wrong. I click the parameters and enter them. I click 'OK' and the parameter value still says "". I have tried deleting the parameter, re-adding it, etc. Nothing is fixing...

Hi, I created a view to utilize in a universe. When I do a select * from the view in sqlplus, it returns fine. No errors. When I add this view to a universe and then query off it, I am getting the ORA-01722 Invalid number error. Why is BOE throwing an error when the view is fine in sqlplus...

Hi, We have a user who has Windows 7 who can't edit existing webi docs or create new ones. The webi tab gets closed and then Windows recovers the tab - back to InfoView. I had him change his webi preferences to use "interactive" for creation/editing, so it must be java related. I had him...

Is there a way you can take the results of a webi query and use those results in another tab in a webi report? Any feedback would be appreciated!!

I didn't enforce the joins, but I just went and tried it, and it is giving me the same results. It is driving me crazy. My datasource is an Oracle 10g database. Nothing out of the ordinary. Okay I just realized that I have a statement in the select expert that says where item_num < 900...

I created the links through the database expert, not the selection formula.