Hello!
I hope you don't think the tittle was a click-bait if you think the report is not challenging enough ;D
(http://www.juanilabaca.cl/dl/ReporteProg.PNG)
I need to make a report like the image above, over a Transformer PowerCube. The cube already has the following (names are in spanish, but I think it doesn't prevent understanding the problem):
DIMENTIONS:
- Nombre de vacuna
- Dosis
- Grupo de Edad
- Month
MEASURES:
- Vacunas administradas
- Población
Need to accomplish the following:
- "Cobertura" is a calculated column: "vacunas administradas" / "población", but only with total at "Dosis" (in the above image, total rows are light blue and are placed above, not bottom).
- "Vacunas administradas" total at "Dosis" must SUM all "Grupo edad" except last one, wich is always "Fuera de cobertura". Ex.: In the above image, for "BCG - Única - Enero", "Vacunas administradas" is 225, because is adding only 215 of "Recien nacido" and 10 of "Menor de 1 año", but ignoring 3 of "Fuera de cobertura".
- "Población" measure need to be visible only for total row.
I'll post the results of my attempts soon.
It's also possible to send someone the powercube.
You would get a much better response and support if you try to do a similar report using a Cognos Sample PowerCube.
Believe when I say I did think of that, but I don't have the samples installed and installing it is not an option. I'm trying to find an MV with the samples I think I have.
But I can share the powercube file, you can download it here: https://www.juanilabaca.cl/dl/dbvp_cobertura_2017.mdc (https://www.juanilabaca.cl/dl/dbvp_cobertura_2017.mdc).
I assume you know how to use dimensional functions.
You would have to play with filter one.
If you need exact expression then I think you should build your report against Cognos sample cube rather then ask everyone to configure your cube :-)
I think the same :-[
Tomorrow I will have a MV with cognos and samples, and I'll do it that way, then make a new post.
Thanks! ;)