I have no idea where to post this because the redesign as made things much more difficult.I had book marked the following because BusinessObjects Web Intelligence is my primary area of interest...https://community.sap.com/t5/c-khhcw49343/SAP+Business...
BusinessObjects BI 4.3 was released almost four years ago, but my company upgraded from 4.2 just over a year ago and we are still learning and figuring out the particulars of the new interface. We did a subsequent patch a couple of months ago and are...
We upgraded from BusinessObjects environment from 4.3 SP02 Patch 8 to 4.3 SP03 Patch 8 one month ago. It went relatively smoothly with no major issues discovered yet. We had begun targeting 4.3 SP03 Patch 5 about 6 months ago, but one week before we ...
We have all seen questions with sample data provided as text like this...ID | Some Description | Some Date | Some Number1 | Whatever… | 1/15/2024 | 1502 | Something else… | 1/31/2024 | 2003 | Still more… | 2/1/2024 | 500Or in a table...
We have 4.3 SP03 Patch 5 installed in our test environment. I came across an odd issue in Web Intelligence which I have reduced to this. In a free-hand SQL query when prompting for a date I do not get the calendar by default. Instead, I get this…
...
You could create a variable something like...=If [Hour of Sale] = "12am" Then 0ElseIf [Hour of Sale] = "1am" Then 1...ElseIf [Hour of Sale = "10pm" Then 22Else 23and sort by that.Or put a custom sort on your [Hour of Sale] column.
We do not use WebI in this way so I am not sure. The only thing I can think of to have you try is to remove the double-quotes from around your @Prompt() function.
We did this a few years ago with a third-party tool which suggests you could do so with the SDK. I have no experience using the SDK. I would bet @DellSC would have some guidance for you.