Seagate Crystal Info 7.0 - Cubes

[jrdatla]

Hi Forum:
I am using the crystal Info cube designer for designing
of cubes on our warehouse.

I am tyring to find out whether we can obtain the following.

I have cube with the following dimensions and measures:
Dimensions A, B, C
Measures D, E, F, G, H

The measures D, and E are calculated from the data in the
table for whatever dimension we choose but the measure F
must be calulated on the basis of the value the cube
returns for D and E. i.e. F = D/E.

I am giving you ann example here.
My table has the following date:
Loan type A B
X 5 60000
Y 8 90000
X 13 90000

I create a cube of this table to show the measures(Average) for A and B and aslo it has to show one more measure C which is equal to the measure A/ Measure B.

Measure A :- Measure A Measure B
X 9 75000
Y 8 90000

The measure C has to give me the following
( 5 * 60000) + (13 * 90000) / (60000 + 90000)

I have also one more colums which calculares the A * B too.
So what I require and i wish to know is is there any way to divide the output of Measure A with Output of measure A to give Measure C.

Measure C = output of Measure B/ output of measure A.

Is there any way to solve this using Seagate Crystal Info 7.0.

Thanks in advance and I would appreciate if you can post
me the solution in detail.

 

[jrdatla]

Hi Forum:
I am using the crystal Info cube designer for designing
of cubes on our warehouse.

I am tyring to find out whether we can obtain the following.

I have cube with the following dimensions and measures:
Dimensions A, B, C
Measures D, E, F, G, H

The measures D, and E are calculated from the data(Sum) in the
table for whatever dimensions we choose but the measure F
must be calulated on the basis of the value the cube
returns for D and E. i.e. F = D/E.

Given below is an example:

The cube returns the folowing when we browse the cube.

LoanType D E F
X 20 40 0.5
Y 180 60 3
Z 100 50 2

As you see from the above output, The measure F depends on the Value D and
Value E returned by the cube. F = D/E.

The cube has to show the value of Measure F as the value of D / Value of E
when we browse the cube.

Is there any way to solve this using Crystal Info 7.

Thanks in advance and I would appreciate if you can post
me the solution in detail.