Author Topic: Help me with ideas to address a challenging report  (Read 139 times)

Offline qvixote

  • Community Leader
  • *****
  • Join Date: Jul 2013
  • Posts: 111
  • Forum Citizenship: +1/-0
Help me with ideas to address a challenging report
« on: 10 Jan 2019 02:38:49 pm »
Hello!

I hope you don't think the tittle was a click-bait if you think the report is not challenging enough  ;D



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.


Offline stork

  • Full Member
  • ***
  • Join Date: Jan 2006
  • Posts: 46
  • Forum Citizenship: +0/-0
Re: Help me with ideas to address a challenging report
« Reply #1 on: 11 Jan 2019 08:02:22 am »
You would get a much better response and support if you try to do a similar report using a Cognos Sample PowerCube.

Offline qvixote

  • Community Leader
  • *****
  • Join Date: Jul 2013
  • Posts: 111
  • Forum Citizenship: +1/-0
Re: Help me with ideas to address a challenging report
« Reply #2 on: 14 Jan 2019 06:48:14 am »
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.

Offline stork

  • Full Member
  • ***
  • Join Date: Jan 2006
  • Posts: 46
  • Forum Citizenship: +0/-0
Re: Help me with ideas to address a challenging report
« Reply #3 on: 14 Jan 2019 07:47:24 am »
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 :-)

Offline qvixote

  • Community Leader
  • *****
  • Join Date: Jul 2013
  • Posts: 111
  • Forum Citizenship: +1/-0
Re: Help me with ideas to address a challenging report
« Reply #4 on: 14 Jan 2019 09:27:06 am »
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!  ;)

 


       
Twittear