Hi, any chance you still have that jmeter script you're referencing?

Using the Cognos Analytics (11.2.4) REST API, but the documentation is lame.  The "reference" is a minimal swagger page.  There appears to be no actual documentation for the REST API.

At one point in my script, I'm getting a response that says:

error, see logs

Investigating where said logs may be, I see in my session:

logEnabled   : False

I didn't see any way when creating the session to enable the log.  Is this a system-wide setting?  How do I enable logs for REST API sessions?  Where do the logs live?

Quote from: Suarez on 05 Dec 2024 03:56:45 AMMFGF thanks for your reply.
Yesterday after posting in the forum I continued to do some tests on the new Cognos installation and I realized that the content of the Launch menu for the same user, who should be a simple user who can consult some reports and that's it, varies depending on of the browser used, Firefox shows all the possible options, Edge and Chrome instead a reduced selection (I attach screenshots to clarify).
So if I understand correctly, I have to check which default groups/roles these users belong to in Cognos Administration and modify the right operational capabilities for those groups/roles.
A thousand thanks.You cannot view this attachment.You cannot view this attachment.

Hi,

The browser thing is what we'd call in the UK a "red herring" - something that looks promising but leads you off in entirely the wrong direction. Query Studio, Analysis Studio and Event Studio are only supported in Firefox and Internet Explorer in Cognos 10. Regardless of security, you won't see those studios shown in Chrome or Edge - because they are not supported in those browsers. It has nothing to do with your security capabilities in this case.

To fix the issues you are seeing, you need to check firstly that each user belongs only to the groups and roles they should have access to, then set the capabilities of those groups or roles to allow access only to the studios they need to be able to use. Also, check the security of the folders in the Public Folders area to make sure they are locked down and accessible only to the appropriate users.

Cheers!

MF.

I'm looking to create a combination chart where there are 2 clustered bar charts side-by-side instead of on top of each other.  One would use the primary axis and the other would use the secondary axis.  When I add the visualization to the report I'm selecting Charts from the drop down in the upper right and then selecting Combination / Clustered Bar.  Everything I try stacks the 2 charts on top of each other.  See the attached screenshot for an example of what I'd like to do.  Any help is appreciated.  Thanks.

MFGF thanks for your reply.
Yesterday after posting in the forum I continued to do some tests on the new Cognos installation and I realized that the content of the Launch menu for the same user, who should be a simple user who can consult some reports and that's it, varies depending on of the browser used, Firefox shows all the possible options, Edge and Chrome instead a reduced selection (I attach screenshots to clarify).
So if I understand correctly, I have to check which default groups/roles these users belong to in Cognos Administration and modify the right operational capabilities for those groups/roles.
A thousand thanks.You cannot view this attachment.You cannot view this attachment.

Hi
I have a crosstab report with
hierarchy rows having Hier 1, Hier 2, ... Hier 8,
in column, Year from 2025 - 2032 and a numeric measure.

I must color the measure looking at previous years starting from 2026.


I looked into all the threads but I am unable to find a simple solution.

Here is the sample data
Count   2025   2026   2027   2028   2029   2030   2031   2032
Hier1    100    120    122    132    110    120    90    80
Hier2    50    60    61    66    55    60    45    40
Hier3    50    60    61    66    55    60    45    40

Columns 2026, 2027, 2028 2030 must be in green
Columns 2029, 2031, 2032 must be in red

Looking for a function, a simple solution that looks up to the previous year and formats the cells in green or red.
I did search in the forums but unable to find a solution for the conditional formatting.


Thanks

Try setting the following - You may need to restart services for these to take effect:

RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS - 1000000
RSVP.EXCEL.EXCEL_2007_OUTPUT_FRAGMENT_SIZE - 1000000
RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET - TRUE

This is what we have our relevant setting set as.
Hope this helps,
Adam.
 

If I have a map on dashboard showing results for "all" states, how can I recenter the map on a particular state (I have a linked drop-down list) once I choose a particular state.

Initially, it comes up showing all the US, when I select say 'NY', I want the map to recenter itself and basically show 'NY' only and not continue to show the entire US map.

Any thoughts would be greatly appreciated.
Thanks,
Adam.

Quote from: Suarez on 04 Dec 2024 04:40:00 AMHi everybody, had to do a fresh install of Cognos 10.2 after old sever's hw died a couple of weeks ago.
I had a back up of the content store but not all the configuration we did.

Now users find in the launch menù links to query studio, analysis studio, report studio, event studio and cognos administration, we only want them to see Cognos workspace link there.



How can i remove those "studio" links?

TIA

Those links should automatically disappear when you set up your security. For example, if a user belongs to only group(s)/role(s) that don't have the Query Studio capability, the user won't see Query Studio in the Launch menu. You need to make sure your groups and roles are defined with the appropriate capabilities, and allocate your users to the desired groups and roles.

Cheers!

MF.

Hi everybody, had to do a fresh install of Cognos 10.2 after old sever's hw died a couple of weeks ago.
I had a back up of the content store but not all the configuration we did.

Now users find in the launch menù links to query studio, analysis studio, report studio, event studio and cognos administration, we only want them to see Cognos workspace link there.



How can i remove those "studio" links?

TIA