Business Objects Expert Help need to complete 1 report
$30-60 USD
Closed
Posted over 15 years ago
$30-60 USD
Paid on delivery
Business Objects XI Deski Report that uses RunningSum.
CrossTab report from 2 different queries needs to include RunningSum with Accurate count in each Cell.
Currently there are Empty or Blank cells....these need to have correct and accurate information.
These Cummulative RunningSum figures need to be used in the Crosstab report in a Formula to Create a Percent.? ? Example.? ? <Hour Value> / <Runningsum>
Online Chat time is required once we? begin.
## Deliverables
For the purpose of explanation only:?
This report deals with Active Computers in different States (Regions)
Final Needed Requirement:
CORRECT 1 CrossTab report to show the accurate uptime (%) of computers by State and (Monthly? ? OR? Weekly).
Example:
? ? ? ? ? ? ? ? ? ? Jan? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Feb? ? ? ? ? ? ? ? ? ? ? ? ? ? Mar? ? ? ? ....
FL? ? ? ? ? ? ? 99.9799%? ? ? ? ? ? ? 98.9799%? ? ? ? 99.8890%
Ga? ? ? ? ? ? ? ? 98.8877%? ? ? ? 99.9799%? ? ? ? ? ? 80.0009%
Wa? ? ? ? 99.4444%? ? ? ? ? ? ? ? 98.5555%? ? ? ? ? ? ? ? 90.4445%
...
What I have so far:
1) CrossTab and Query that gives the Total Downtime for the computers by State/Month, State/Week
2) Query? for Total # of Active Computers there are per State Prior to 1/1/2008.? ? (****This is completed)
3) Query and CrossTab report that gives a RunningSum? for the States/Month.
Example:
? ? ? ? ? ? ? ? Jan? ? ? ? ? ? ? ? feb? ? ? ? ? ? ? ? Mar
FL? ? ? ? 4? ? ? ? ? ? ? ? ? ? ? ? 8? ? ? ? ? ? ? ? ? ? ? ? 20
Ga? ? ? ? 5? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 10
WA? ? ? ? 4? ? ? ? ? ? ? ? ? ? ? ? 8? ? ? ? ? ? ? ?
What I need help with and or Completed.
1)? ? Adding "0" records to the CrossTab report for #3 above so that the RunningSum works correctly.
2)? ? Adding the Total # of Active computers Prior to 2008 (From #2 above) to the RunningSum CrossTab.? ? Example? Var = <RunningSum> + <Prior2008>
3)? I need the Values from the runningSum Crosstab in #3 above.....moved to the Final CrossTab (of #1 above)
4) I need the Final Percentage Calculations working correctly.
Other inforamtion to know:
1) I am using Deski
2) I do have access to link to personal files.....such as excel and access
3) I do not have access to the Designer
4) I? do not have? access to the Business Objects Admin features