If you're working with a bunch of files and need to automate changes, scripting is your best bet. I've had to deal with similar issues when merging and editing multiple video clip. It's frustrating when everything is all over the place. What helped me the most was finding software that let me edit and piece everything together in one go without too much manual work.

Good Afternoon Cognos Gurus,

This is happening in Cognos v11.2.3.  Unfortunately, I don't have any experience with this function from any prior Cognos releases because this is the very first time I'm trying to use it.

First off, I am a senior level Report Author presumably with significant Cognos accesses assigned to me by some Administrator long ago.  I don't experience the following symptom myself using my routine Window login but other lower-level Cognos users do.

Here is the situation and symptom:
1.  I authored a report.  It is stored in a Teams folder that everyone has access to.  The report contains no prompts.
2.  I used the routine Share function within the Teams Content folder to copy the URL which points to that report uniquely. 
3.  I can successfully use that URL to launch directly to that report using either a desktop shortcut or from an MS Edge browser from the Cognos Production Server or from other servers or workstations.
4.  We use single-sign-on so in either of those instances, I am not interrupted with a Windows login nor a Cognos login.  The report simply renders.
5.  However, when I have other less powerful users attempt to launch using the same URL (via shortcut or browser), more-often-than-not Cognos stops the user and prompts for login.

All users who are testing - and getting this inconsistent but frequent result of the unintended interrupting Cognos login prompt - have already authenticated with Windows login and can successful run and render the report from where it is stored in the Teams folder once they login to Cognos.  I know it sounds crazy but the interrupting login prompt doesn't appear consistently for anyone - some users can launch directly to and render the report just like I can.  At other times, the same users seem not to be able to launch the same URL without being prompted for Cognos login.

Can anyone suggest what settings might be impacting the ability for the report URL to take advantage of single-sign-on and bypass the Cognos login?

Repeating values such as that will happen if the query is being projected below the fact grain.   

I think you would need to confirm what dimensions have relationships to your fact and to what level in each dimension.

For example, assume you have a time dimension consisting of years, months, and days.  Assume that you have a fact table which consists of facts which exist at the day level.  Assume you have another fact table which consists of facts which exist at the month level.  Cases like this are scenarios such as actual values versus planned values.  If you tried to have a query with a month-level fact and days you will get repeating values.  If you have correctly modelled, the summaries should not double count.

Hi, I have an issue in a crosstab I have to create in Cognos Analytics.
The model is a DMR.
The data comes from dimensions, hierarchies and levels from a package created in Framework Manager.

There is a crosstab which is working fine and it has in rows a level from a hierarchy.
The measure is giving correct results for the members of that level.

On the contrary, if I create a new crosstab with the same measure and I put in rows another member coming from a different dimension/hierarchy it is giving the same repeated number for the the members of that level. I mean for all the rows in that column.

I am wondering if the error comes from joins in the model in FM or from the crosstab in CA.

I have tried many solutions but all the time the measure is give a repeating number for all the members in that column.

I am new to DMR models. If anyone could help me please. I really appreciate any advise because I am really stuck with this issue.

Thank you

Quote from: burtonl on 19 Mar 2025 08:05:14 AMHello!  I am new to this website.  I am getting an error and I googled it and found a post with the same error, but I do not see how to view the answer(s) that were given....?????

Hi,

You haven't really made the issue clear enough for anyone to be able to help you. What error are you getting?

Cheers!

MF.

This topic has been moved to Reporting.

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

Quote from: Warm on 14 Mar 2025 10:45:59 AMThank you for the advice. We're using IBM Cognos Analytics 11.2.4.

Couldn't load the XML script into a report. Will look into possibilities to make it work.

You can use the "Open report from clipboard" option to load the XML into a report.

Cheers!

MF.

Quote from: dougp on 21 Mar 2025 02:45:01 PMI knew about that (, said Doug, sheepishly) because I have used it before.

You know, at my age the hearing is the second thing to go.  I can't remember what the first thing was.

Welcome to my world, sir! :-D

Thanks for the further updates also - useful info!

Cheers!

MF.

This topic has been moved to General Discussion & Gossip.

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

Selecting a query subject or query item and using Tools | Find Report Dependencies will also work.

One thing to watch out for:

Both Analyze Publish Impact... and Tools | Find Report Dependencies identify things that you would see in places like Data Items or Detail Filters.  But since the relationships between query subjects are technically not in the reports, removing something like a bridge or grouping table (used only for relationships) won't be identified as something that has an impact.  I suppose that database changes should not be harming how logical relationships work, so maybe that's OK.

For example Report X includes parts that require the SQL to look like
FROM factA INNER JOIN bridgeB INNER JOIN dimC
and I remove table bridgeB and make the relationship work directly between tables factA and dimC, there technically should not be a problem.  But what if I got it wrong?  What reports should I watch to see if I messed this up?  FM won't tell me.  I suppose that, logically, I can assume that anything using dimC must be checked.