Recent content by skrandel

You say they are character, but they are likely nvarchar. BO will not automatically bring those over when you drag a table from the right to the left. You can build them manually and they work fine. This has been a limitation for years. Steve Krandel Intuit

What is 508? Steve Krandel Intuit

All you can do is not allow the users to schedule it at all and have it scheduled by an admin. Steve Krandel Intuit

You trying to do this in the report or in the universe? Steve Krandel Intuit

So, forums like this can't teach you how to do this. Do you already have a universe on top of the Service Desk database. If so, just jump in and write a query. If not, you're in for a long one. Steve Krandel Intuit

You can always us the results in as many tabs as you want within the same document. You cannot use them in a different webi document. Steve Krandel Intuit

And I also can't do math. 16/24 = 2/3; not 3/4. Never mind. I didn't help at all. Steve Krandel Intuit

I think that's exactly what I suggested. OK, I forgot to mention to trunc(sysdate). Glad it's working. Steve Krandel Intuit

try to see if sysdate + .75 returns today at 4:00 pm (16:00). If it does, then you can just do sysdate+1.75 to get tomorrow at 4:00 pm. Steve Krandel Intuit

That simply doesn't make sense. InfoView simply uses your browser's print settings. Or you have to set your printer in Acrobat Reader if you are viewing as PDF. Steve Krandel Intuit

Without knowing the calculations, it's impossible to guess. Seems like basic variables would do it. Max() for each of your measures would do exactly what you want. You can do this in the report or do it in the universe. Steve Krandel Intuit

If you are bringing back only this column, then it does what you want by default. If you are brining back other columns, then, no. Each row of a report will display if there is something unique about it. Steve Krandel Intuit

This is basic funcionality. You could either do this in the query with a condition or on a report with a filter. Filters have the ability to do all the operators. Not sure what the problem is. Just don't try to filter the column. Filter the block and it will be obvious. Steve Krandel Intuit

SP2 was where the last big changes were. BO does not and has never done sub-reports. WebI is not limited at all. In fact it has more capability than client now. The only significant thing missing in my opinion is the ability to group dimensions without doing if-then-else. Hiding a column is...

The online help is really good. A report formula like this would work: if [date_object1] > RelativeDate(CurrentDate();-22) then "No" else if [date_object2] > RelativeDate(CurrentDate();-22) then "No" else "Yes" Steve Krandel Intuit