Yeah I figured that out after I thought about it. Thank you for the advice
Bret Pothier
Business Analytics
IRVING OIL
C 506.271.1507
**To report an issue with TM1Web, Planning Analytics, PAX, or Cognos Analytics, please create a ticket with OneIT Services: Business Analytics Request - One IT Services (service-now.com)
Irving Email Disclaimer: This communication and its attachments are confidential and may be privileged. If you are not the intended recipient, please immediately notify the sender and then delete this communication and its attachments without reading it or forwarding it. Many thanks. Le présent courriel et les fichiers qui y sont joints sont confidentiels et contiennent peut-être des renseignements protégés. Si vous n'êtes pas le destinataire prévu, veuillez en aviser immédiatement l'expéditeur puis supprimez, sans les lire ni les transférer, le présent courriel ainsi que les fichiers qui y sont joints. Merci. . This communication was sent by Irving Oil. Contact information for Irving Oil can be found at:
http://www.irvingoil.com/who_we_are/contact_us/ If you do not wish to receive future Commercial Electronic Messages from Irving Oil, please click on the following link to unsubscribe:
unsubscribe@irvingoil.com Ce message a été envoyé par Irving Oil. Les coordonnées d'Irving Oil se trouvent à :
http://www.irvingoil.com/fr/qui_nous_sommes/nous_contacter/ Dans le future, si vous préférez ne pas recevoir les messages commercials électroniques de Irving Oil, vous pouvez vous désinscrire en cliquant sur le lien suivant:
unsubscribe@irvingoil.com
Original Message:
Sent: 6/24/2024 7:45:00 AM
From: Julian Sedgewick
Subject: RE: Consolidation of measure not populating
Hi Bret,
I'm not too familiar with Cognos BI but in the TM1 engine it wont naturally consolidate strings.
Is the "dateretired" measure a string?
J
------------------------------
Julian Sedgewick
------------------------------
Original Message:
Sent: Fri June 14, 2024 12:06 PM
From: Bret Pothier
Subject: Consolidation of measure not populating
I am having an issue with Consolidations. When I look at the asset record in question I can see it has a retired date of May-24. I can also see it in Ma-24 of the consolidated period of May-24-YTD but it is not listed at the top level.
When I put this cube into a Cognos Report the date shows when I select the subset Current Fiscal Period YTD (which equals May-24 YTD) but it is not showing in the cube itself. I am now using PAW books to produce these reports because they have become too much for Cognos to handle but I am not seeing the same results.
Is there a way to get the date pushed to the top level of the consolidation? It is also not working for my Quarter subsets the exact same way.
Any help would be appreciated
Thanks
------------------------------
Bret Pothier
------------------------------