Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem while creating measure objects in Universe

Status
Not open for further replies.

devnaren

Programmer
Aug 23, 2007
49
US
Hi All,

I am trying to create measure objects using Business Objects Designer to get Beginning Balance and Ending Balance for a yearperiod in general ledger reports

I coded in such a way that:

Beginning Bal:(measure object)
select
sum(bgbal)
where
<here i dont know what to written here>


Ending Bal: (measure object)
select
.............
where
.............


Can anyone know how to get the beginning and ending balances for general ledger reports
 
You can't calculate this in a universe. You need an database field that stores it.

Steve Krandel
Intuit
 
You could potentially used a derived table to get each of these dimenstions. However, it will slow down reports and you would have to make sure to provide other fields that can be used to link the derived table to, for example, the account it applies to.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top