Hello,
At the moment, I'm having trouble displaying precalculated data at the Framework level in a crosstab.
I have the following crosstab
The fields <#Somme(Code CC)#> and <#Somme(Code Groupe)#> are obtained with the aggregate function sum on the fields <#Code CC#> and <#Code Groupe#> from the DATA menu.
Their expression generated by Cognos is: total(CurrentMeasure within detail [Code ___])
"Récapitulatif" is just basic text.
As the sum results on the fields
Tot CC and moreover
Ratio CC are not satisfying at all, we chose to pre-calculate them in the Framework and replace them in the corresponding boxes in the crosstab.
hierarchy scheme:
A "groupe" is made of all the "CC" hence <Tot Gpe> and <Ratio Gpe>
A "Société" is made of all the "groupes" hence <Tot Soc> and <Ratio Soc>
Their expressions are:
• <Tot Gpe> = total([Tot CC] for [Type] ;[Axe]; [Annee] ; [Code Société] ; [Code Groupe])
• <Ratio Gpe> = if ([Tot Gpe] = 0) then (0) else ([Tot Gpe] / [Tot Gpe par Annee])
• <Tot Soc> = total([Tot CC] for [Type] ; [Axe]; [Annee] ; [Code Société])
• <Ratio Soc> = if ([Tot Soc] =0) then (0) else ([Tot Soc] / [Tot Soc par Annee])
with
• <Tot Gpe par Annee> = total([Tot CC] for [Type] ;[Annee] ; [Code Société] ; [ Code Groupe])
• <Tot Soc par Annee> = total([Tot CC] for [Type] ;[ Annee] ; [Code Société])
A total and a ratio still need to be calculated on the same scheme for all the "sociétés"...
When I ask Cognos to display the data from the query I get an error message PCA-ERR-0062 " the 'cn' knot should not be a 'value' " *
unless I change <#Somme (Code CC)#> into 'Somme Code CC', it is the same for Code Groupe.
When I try to run the report with the above fields renamed I get the crosstab but the boxes I filled (unlock the crosstab boxes and define the content in the property menu) with the specific values <Tot Gpe>, <Ratio Gpe> <Tot Soc> and <Ratio Soc> remain empty.
How to make this work?
Any help is welcome... Any further information will be given if asked.
Thanks a lot
*translated from French...
