Search results for query: *

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

Are you running the report interactively? This looks like a timeout to me. How long did it run before giving the error. You need to check all the timeout settings and make sure they are what you want. Steve Krandel Intuit

Stop thinking about doing this with BO. How would you do this with SQL. If the only thing in Clarity that would identify the user is the user_ID, then you either need a cross reference to make the ids match BO or just make them match from the start. If you are on XI 3.1, look at the...

If you need it to provide the security in all cases, then you need to create the filter in the universe and then have the filter object defined so that it's ALWAYS applied. Steve Krandel Intuit

These types of tools are intended to be put on proper databases. If you have 47 queries, then you asking the tool to do much more than it was intended for. Some sort of data aggregation should be done regardless of the reporting tool you use. In your case, Business Objects cannot do any more...

I'll say it........ You do not have a report. You are using a report to build a data mart. Then you are trying to use Excel to cut this thing up into pieces. No report should have that many queries. It simply makes no sense. You should run the 47 queries to load a proper database and...