Recent Posts

Pages: [1] 2 3 ... 10
1
Upgrading to Cognos Analytics / Upgrading 11.0.7 to 11.2.1 - Authentication in all namespaces
« Last post by Rehtaeh209 on Today at 09:21:47 am »
Hello,

I have a two system environment in a pretty small shop.  I was able to upgrade our test environment with little trouble from 11.0.7 to 11.2.1.  When I went to upgrade the production environment I get the AAA-AUT-0013 The user is already authenticated in all available namespaces error when I go to the web login page. 

I have already reviewed and done everything on this page: https://www.ibm.com/support/pages/aaa-aut-0013-user-already-authenticated-all-available-namespaces-1
Quote
Modify the gateway URI, Dispatcher URI and content manager URI from localhost to actual server name (or IP address, or FQDN)
Set the IBM Cognos Application Firewall to True
Test all the namespaces and make sure all test successfully. (if these fail then make sure bind credential for the namespace are set correctly)
In the namespace, make sure selectable for authentication is set to True.

As well as this page: https://www.cognoise.com/index.php?topic=34570.0
Quote
Actions
Edit Global Configuration...
In Cookie Settings
    Domain = your server name (like in Local Configuration/Environment/Controller URI for gateway = http://server name/ibmcognos/controllerServer)
    Path = /

We use Active Directory to connect via IIS.  I've looked through all of those settings and can't find anything.  I even walked through the IIS configuration instructions here: https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=services-configuring-iis-in-cognos-analytics

If someone has any additional thoughts of what I could try, I'd greatly appreciate it.
2
Administration and Security / Re: Connect Cognos to SSAS Cube
« Last post by cognostechie on 29 Nov 2021 03:02:00 pm »
It turns out that some consultant made a FM Model using the SSAS Cube and published the package. When I open the model and publish the package again, it works fine and I can see the data in the report. However, I don't see any Data Source in the model but it still publishes the package ! I am wondering is there a different way to make a FM Model for SSAS cube? When we make a model for SSAS Cube, don't we have to select a Data Source? 

I can't upload an attachment. It says 'cannot access the location'.

Basically, there is + sign in the namespaces and package because there are objects inside them but there is no + sign in the Data Source !
3
Dashboards / Re: multi select list in dashboard Cognos 11.1 R7
« Last post by MFGF on 29 Nov 2021 12:58:28 pm »
Quote from: so10070 on 29 Nov 2021 12:07:27 pm
Is it possible to create a multi select list as a visualisation in Cognos Dashboard.  I can't find any other visualisation as "list".

Hi,

Have you looked at bringing in a "Table" object from the Visualizations pane? It sounds like this is what you're looking for?

Cheers!

MF.
4
Dashboards / multi select list in dashboard Cognos 11.1 R7
« Last post by so10070 on 29 Nov 2021 12:07:27 pm »
Is it possible to create a multi select list as a visualisation in Cognos Dashboard.  I can't find any other visualisation as "list".
5
Administration and Security / Re: Connect Cognos to SSAS Cube
« Last post by cognostechie on 22 Nov 2021 07:40:55 pm »
Yes, absolutetly. In fact, when you make a new FM model, that check box is selected by default and I just keep it that way.
Testing from the Data Server window tests successfully.

We have opened a ticket with IBM, let's see what they say.
6
Administration and Security / Re: Connect Cognos to SSAS Cube
« Last post by MFGF on 22 Nov 2021 07:56:49 am »
Hi,

As your connection is a Data Server connection, there's really no point testing it in the Admin Console - this will test using both Compatible and Dynamic, and (as you are seeing) the Compatible test fails, as the connection is not Compatible-query. I would stay out of the Admin Console altogether and test just via the Data Server dialogs to avoid confusion.

A quick sanity check. When you are creating a new FM model,  and you are in the New Project dialog box (where you specify a name and location for the project), are you definitely checking the "Use Dynamic Query Mode" check box?

Cheers!

MF.
7
Reporting / Re: Group By and Average Calculation
« Last post by t0mato on 22 Nov 2021 07:37:50 am »
Any ideas? I was thinking an actual written expression was needed for this.
8
Reporting / Re: Group By and Average Calculation
« Last post by t0mato on 19 Nov 2021 11:06:29 am »
Quote from: dougp on 19 Nov 2021 10:40:00 am
Set the Detail aggregation property for [Applicant Email Address] to Count or Count Distinct.

Thanks for the response! And when running this, it will provide an average of the applications per day? Or is there an additional step needed here?
9
Reporting / Re: Group By and Average Calculation
« Last post by dougp on 19 Nov 2021 10:40:00 am »
Set the Detail aggregation property for [Applicant Email Address] to Count or Count Distinct.
10
Reporting / Group By and Average Calculation
« Last post by t0mato on 19 Nov 2021 08:17:55 am »
Hello!

I am working with some HR Data and looking to calculate the following: Average rate of applications per day

Data Items:
[Date Applied] - the date in which the applicant applied
[Applicant Email Address] the email address of the applicant

If I have a data item [Date Applied], my thoughts are that I will simply need to do some kind of Group By on [Date Applied] and COUNT the number of [Applicant Email Address] for each [Date Applied], then get an average of the count of [Applicant Email Address] per day.

My only challenge is writing this expression as I am not familiar with a Group By function or how to write this. Could someone please assist here?

Thanks in advance!
Pages: [1] 2 3 ... 10
BSP Software Articles
Populating Framework Manager Descriptions from SQL Server Extended Properties
Performance Monitoring in MetaManager™

BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel TD SYNNEX
Security Migration Twitter - TD SYNNEX IBM Cognos
Integrated Management Suite ExitCertified - Cognos Training