Problem while creating measure objects in Universe

[devnaren]

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 Balmeasure 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

 

[skrandel]

You can't calculate this in a universe. You need an database field that stores it.

Steve Krandel
Intuit

 

[hilfy]

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.

 

[devnaren]

Thanks guys for your valuable answers.....