I discovered the problem ... I am using another dimension that separates the values in two situations and in this case the values can not be summed apart as in the final result! I'll analyze better and see what I can do, but if anyone has an idea, thank you very much !!

Sorry for the english, but I'm from Brazil and I'm using a translator !!

Grateful Gianni Ceresa really worked out I will check if you have other rules that are changing my result!

There is a variable that alternates between months, bimester, quarter or semester so I do not know if it would work, but I'll try !!

I tried to force the rule with sum but there it is giving a higher value than it should! I'll post a picture of the results!

@Andrew Fomin. again, thank you! I just have to thank, because I have learned a lot from the community, and the contents of the work that has been done by all! See you!

Andrew grateful! I found the problem. In fact it was the ETL that was missing the load of a table! Gradually I come to evolve and maybe one day be able to help people like you in the community. Big hug. Daniel.

How am newbie has certain things that still can not understand, I'll see if I can turn the log and post it here. Grateful! Daniel

It worked. Look at the log and realized that the credentials file was relative path and thus would not start the user and password information. I changed the script and looked like this: #/bin/bash function dowRpd(){ atualizaData ${DIR_SCRIPTS}/data-model-cmd.sh downloadrpd -O ${DIR_BKP}/${DIR_RPD}/OracleBi-${DATA}.rpd -SI…

ok, I'll do a test and return to the result. thank you so much

It does not generate error message and have tried to root. follows the script: #/bin/bash function dowRpd(){ atualizaData ${DIR_SCRIPTS}data-model-cmd.sh downloadrpd -O ${DIR_BKP}${DIR_RPD}OracleBi-${DATA}.rpd -SI ssi -U ${USUARIO} -W ${PASS} -P ${PASS} >> $ARQ_LOG 2>&1 } function dowCat(){ atualizaData…

In fact the problem was that the database password had expired. It worked. Thank you so much.

Red Hat Enterprise Linux Server release 6.7 (Santiago) Oracle Linux Server release 6.7 64bits

I'm having the same problem. You could solve the problem? What did you do?