I am new to business objects, as is our company. I have experience with crystal reports.
The specific problem I am having is a performance issue, I think? The universes are created by the company responsible for the ods, classes, objects, etc.
I am creating a report that is variable intensive and the variables are dependent on the resolution of previous variables before the current variable can compute.
For instance, I have will have 12 months from january to december. each month will be allocated a portion of an annual amount as a monthly amount.
I will always be working with a 12 month range from the first of the year to the end of the year however, the start date and the end date could fall outside the first of the year and the end of the year. In this instance, i will always use the first of the year and the end of the year as cut offs.
All records will have either a start date greater than the first of the year or an end date less than the end of the year.
So, If I have a record with a start date of 02/01/04 and an end date of 01/31/09 then January will get nothing and February will get a full month as well as March, April, May and so on for the remainder of the year.
If I have a record with a start date of 05/01/099 and an end date of 05/31/04, then Jan gets a full month, feb gets a full month on through to may and June to the end of the year will get nothing.
The pattern is fairly obvious and appeared to be fairly straight forward?
I have variables that work and do what i want, but when I get over to October, the report "chokes". The performance has been degrading as I add additional months, but at October it is dying.
Also, when I open the report to work on it, it is taking 10 to 15 minutes to open in design mode. It is as though it is computing all variables each time. When I make modest changes to variables, the report must compute each variable?
To update the report now takes 15 to 20 minutes.
I am searching for clues but have found none.
Suggestion?
stan
The specific problem I am having is a performance issue, I think? The universes are created by the company responsible for the ods, classes, objects, etc.
I am creating a report that is variable intensive and the variables are dependent on the resolution of previous variables before the current variable can compute.
For instance, I have will have 12 months from january to december. each month will be allocated a portion of an annual amount as a monthly amount.
I will always be working with a 12 month range from the first of the year to the end of the year however, the start date and the end date could fall outside the first of the year and the end of the year. In this instance, i will always use the first of the year and the end of the year as cut offs.
All records will have either a start date greater than the first of the year or an end date less than the end of the year.
So, If I have a record with a start date of 02/01/04 and an end date of 01/31/09 then January will get nothing and February will get a full month as well as March, April, May and so on for the remainder of the year.
If I have a record with a start date of 05/01/099 and an end date of 05/31/04, then Jan gets a full month, feb gets a full month on through to may and June to the end of the year will get nothing.
The pattern is fairly obvious and appeared to be fairly straight forward?
I have variables that work and do what i want, but when I get over to October, the report "chokes". The performance has been degrading as I add additional months, but at October it is dying.
Also, when I open the report to work on it, it is taking 10 to 15 minutes to open in design mode. It is as though it is computing all variables each time. When I make modest changes to variables, the report must compute each variable?
To update the report now takes 15 to 20 minutes.
I am searching for clues but have found none.
Suggestion?
stan