I wish to effectively create a "prompt" on a dashboard based on a date column to enable me to select Current Period vs. Prior Period.
Current Period would represent X months of data within the Data Set/Data Module and Prior Period would be the X months immediately prior to Current Period chosen.
Ideally, the selection of X months (or the driving criteria) would be entirely dynamic in the dashboard by the particular user and would not be known at DataSet/Data Module creation.

The current and prior period need to be calculated at Dashboard run time, not Data Set creation time.
One user may want to compare 1/1/2024 - 12/31/2024 (12 months) as Current Period against 1/1/2023 - 12/31/2023 (immediate prior 12 months to current period of 12 months) as Prior Period.
The next user may want to compare 1/1/2025 - 3/31/2025 (3 months) as Current Period against 10/1/2024 - 12/31/2024 (immediate prior 3 months to current period of 3 month) as Prior Period.

If I was in a Report as opposed to a Dashboard, I would create a calculation based on a prompt for the current period that would determine all the current period rows and all the prior period rows.
I could then setup calculations for variances, etc.

However, I don't know how/if this dynamic calculation is evenpossible in a Dashboard?
Any thoughts/suggestions would be greatly appreciated.

Thanks in advance,
Adam

Are you using Azure AD as your authentication provider?

And you don't have your models in source control (git, svn, etc.)?  I use git.  Before pushing to my remote repo, I use https://www.html-tidy.org/ (with appropriate command line arguments) to tidy the XML so that diffs are readable.  It's probably good (if you're not using them) to exclude your models' .log files from git.

There is a way to get this from the Content Store database, but querying the Content Store directly is not supported.

There may be a way to get this through the Cognos Analytics SDK.

I vaguely remember someone explaining how to export a package from Cognos.  I think you get only the elements related to that package -- so, probably not the entire model.  I probably saw that on this site, so keep searching.

I'm sure companies like Motio or BSP make products that can help with this.

Hi everybody, Cognos Version is 10.2
After a recovery/restore due to hw server fails we have a problem.
In the IBM content administration we see all the packages we had and the reports works
In the framework we don't have all the project we used to work on.
Is it possible to create a new project importing model data from an already published package?

How do I burst a report with 2 pages. The 2nd page is a detail in master detail relationship. When I try to burst it fails and says you cannot burst a bested query.

What's the name of that mathematician (French?) who wrote something along the lines of 'I've found the solution to   (some problem which if I had paid more attention I might have better remembered this)'?

Thanks dougp for the input.

I'll give it a try.

In this case, the data is in Cognos database is SQL (the source originates from an IBM DB2 database).

What RDBMS?  If it's MS SQL Server -- https://learn.microsoft.com/en-us/sql/t-sql/statements/collations?view=sql-server-ver17

So you join looks like

Query1.ColumnA = Query2.ColumnB
Convert one side to the collation of the other side.

Query1.ColumnA COLLATE SQL_Latin1_General_CP1_CS_AS = Query2.ColumnB
Keep in mind that I exerted zero effort to make sure this is correct. You can do your own research to determine which column must be converted to which collation.  And I don't know if that can be done directly in a Cognos join.  You may need to find another way to make these data sources compatible.

Disregard...found my problem.

Good Morning Cognos Experts,

I'm using Cognos 11.2.3 to Join two queries together using the only data item that the queries have in common. 

However, though these character data items are known to contain the exact same values, they are in fact from two different tables.

The queries run successfully alone.  But when I attempt to run the JOIN query which is using only "=" comparison of one data item from each query result set, I get this error message:

"Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CS_AS" in the equal to operation.

I do not have access to Framework Manager to change the source database.  So, I'm looking for ideas of how I might be able to either manipulate the data items prior to the JOIN OR use an expression to populate their values into separate new data items (within their respective queries) which I could then JOIN instead.

Thank You.