This topic has been moved to Reporting.

https://www.cognoise.com/index.php?topic=38362.0

Quote from: cogdevadmin1937 on 17 Apr 2025 10:52:03 AMHello,

I have a report I need to re-create in Cognos Analytics from Excel, that uses a TM1 cube as a data source. Hopefully the screen shot I've included help explain things to the fullest.

I'm running into an issue because the report is going to use 4 different hierarchies within the Time dimension, all with different MUN's. The requirement is the user will choose a Month and Year from a value prompt, take March 2025 for example, and March 2025 needs to be passed to the 4 different hierarchies within the Time dimension. If the user chose April 2024 in the value prompt, April 2024 would need to be passed to the different hierarchies, etc./etc.

Is is possible to create these MUN's in the screen shot based off the value prompt selection?

Thank You in advance.

Mike

Hi,

It depends what your prompt is returning. If it's a full MUN from a different hierarchy, you would have some work to do in order to strip out the relevant Month and Year to insert into new MUNS. If it's returning string values for Month and Year, it would be fairly straightforward to insert these into the MUNs you require. All of this would be done within macros in items in the report, and it would make sense for each macro to reference the parameter(s) for month and year using prompt macros. Most of the MUN would be literal values around this, eg

#'[Income Statement New].[Time].[Time]->[TMR].[Time].[Time].[' + prompt('YearMonthParameter','token','202503') + ' QTD]'#

In the above, the prompt macro references the parameter as the first argument (so use whatever parameter name you need), the data type returned as the second argument, and a default value for the parameter as the third argument.

Hope this gives you a nudge in the right direction.

Cheers!

MF.

QuoteMy date field is in the format 2021-04-08T01:56:28.

Do you mean your varchar column contains values that look like dates?  Or are you working with a datetime data type (which doesn't have a format)?  If it's a datetime, can't you just use the numeric format options for the axis labels?

extract ( datepart , datetime_expression ) or _month ( date_expression ) will get you the month number value, which you could then use in a case statement to get the strings you want. 

The question I have is: Why hasn't your modeler done that for you? For that matter, it would seem to me that these sorts of things (month and day names and abbreviated month names ) should be created during ETL, before the modeler has to.

Hello,
I'm using Cognos Analytic 12.0.3. In a bar chart, I want to display the month (in abbreviated letter format, like Jan., Feb., etc.) on the x-axis. My date field is in the format 2021-04-08T01:56:28. Do you have any suggestions, please?
Thank you.

So, same data available to both Cognos 10 and Cognos 11?  Are you sure?  If any of those 4 values is NULL, the output will be NULL -- in 10 or 11.

[ECode (rv)] || ' - ' || [ThirdNum (id)] || CHR(10) || [EquiCd Desc (blv)] || CHR(10) || [Seriber (au)]

We are getting blank for majority rows in C11 whereas it is working fine in cognos 10.
Pl guide how to fix the yhis concat error in c11.

Quote from: xbroRep on 04 May 2025 12:05:33 PMWhat are the best practices for using Integrated Version Control in Cognos Analytics, especially when collaborating with multiple developers on the same reports and dashboards?

I agree with Doug that multiple developers working on the same report is a bad idea and your question does not seem to be a real life question. Is this a question for a job interview?

Please tell me you mean multiple developers working on individual reports in the same folder.  Multiple developers working concurrently on the same report sounds like a horrible idea.

And what does this have to do with ChatGPT?

What are the best practices for using Integrated Version Control in Cognos Analytics, especially when collaborating with multiple developers on the same reports and dashboards?