Find Jobs
Hire Freelancers

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
Project ID: 3217373

About the project

Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Canton, United States
4.2
14
Member since Jan 28, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.