Aggregated table and Detailed table

[sanchoniathon]

Hello,

We have this aggregated table:


AggreageatedTableA
PrimaryKey       Amnt
------------------------
111                    950
666                    500
777                   1000



DetailedTableB
column1PrimaryKey    ForeignKey         % 
---------------------------------------------
100                            666               0.25
101                            666               0.50
102                            666               0.25
103                            777               0.10
104                            777               0.50
etc...


Question:
will we be aloud to perform from Report Studio AND Query Studio calculations by using the [Amnt]
column from the "AggreageatedTableA" and the [%]
column from "DetailedTableB" to create a new Data Item with the following calculation:
[Amount] * [%]

Ex:
If we take the PrimaryKey = 666 from AggreageatedTableA

We expect to have the following detailed results in a simple list report using columns from both tables
(the aggregated one and the detailed one):

PrimaryKey ForeignKey    %      Amount
666                666           0.25      125
666                666           0.50      250
666                666           0.25      125

[MFGF]

Hello,

We have this aggregated table:


AggreageatedTableA
PrimaryKey       Amnt
------------------------
111                    950
666                    500
777                   1000



DetailedTableB
column1PrimaryKey    ForeignKey         % 
---------------------------------------------
100                            666               0.25
101                            666               0.50
102                            666               0.25
103                            777               0.10
104                            777               0.50
etc...


Question:
will we be aloud to perform from Report Studio AND Query Studio calculations by using the [Amnt]
column from the "AggreageatedTableA" and the [%]
column from "DetailedTableB" to create a new Data Item with the following calculation:
[Amount] * [%]

Ex:
If we take the PrimaryKey = 666 from AggreageatedTableA

We expect to have the following detailed results in a simple list report using columns from both tables
(the aggregated one and the detailed one):

PrimaryKey ForeignKey    %      Amount
666                666           0.25      125
666                666           0.50      250
666                666           0.25      125

Hi,

You'd need to have a relationship linking these two query subjects in your FM model. You also need to think carefully about what you include in the report - if you don't bring in the PrimaryKey from the detailed table, your list would display a single aggregated row for ForeignKey 666, and it doesn't look like this is your requirement?

MF.

[sanchoniathon]

Thank you MF,

I will take into consideration to include the detailed table PrimaryKey because I need to see the detailed rows not only 1 grouped row (not for this need).