Recent content by S4E

I am trying to apply a date function to my reports that will show a rolling 14-day overview (current date and the previous 13 days) whenever the reports are run/refreshed. I have been trying to use the date functions, but I am having little success. Anyone have a solution? Thanks, S4E

Steve: Is the creation of objects for the alias tables done in designer? Do I create a class first and then place all the objects within it, or are the newly created objects placed within the existing classes? Sorry for asking so many questions. I have not had any Designer training, and the...

This is my first go around with using aliases, so please excuse me if I ask a foolish question. I created a universe, and was instructed to create aliases in order to resolve an incompatibility issue. I am now ready to create my query using BO, but the alias tables I created do not show up in...

I am attempting to run a query from a database that has eight (8) tables. Of the eight tables, I have two sets of four tables that share a common variable, with one table from each set sharing a common variable. When I attempt to run my query, I receive the following message: Incompatible...

I created a query within BO that has five conditions. Each of the conditions is listed as a dimension, and has a unique value. After submitting the query, I noticed that it returned values not specified in the condition statements, but displayed the proper condition values. I constructed the...

Thanks, I used the FormatDate(), and was able to achieve the desired results.

I receive an error message when I attempt to create a new variable. The variable I am using in the substring function is designated as "long text" within the universe. The value for this variable is a converted date/timestamp formatted as dd/mm/yyyy hh:mm:ss. All I am trying to do is strip...

You are correct. I converted the Epoch date into a number and read that into an Excel spreadsheet and it does provide the correct response when selecting the proper date formatting. I was hoping that BO would do the same, but all I am getting is a date of 01/01/0000 when I select the format...

The time stamp for my records is listed in UNIX Epoch time, and Business Objects apparently does not know how to handle this entry. I would appreciate in knowing if anyone else has encountered this problem, and how it was corrected. Thanks S4E

I am a new user to BO, and I have a question regarding the "Partial Results" alert that flashes at the bottom of my screen after running my query. Is this alert indicating that my query is retrieving more data than can be displayed? I performed a count on one of my columns, and it indicated...