Recent Posts

Pages: [1] 2 3 ... 10
1
Hello All,

I have created a Dashboard using IBM Cognos Analytics on Cloud/Web. Now for Predictive Modelling I need to integrate with IBM SPSS Modeler Subscription
I am trying to use IBM Cognos Analytics as Source from Source Tab: Clicked on Connection: Edit. After entering the Cognos Server URL its producing an Error:
It says: Failed Connected to Cognos Analytics Server.:

Do we need to enter any port number or any other path in Cognos Server URL
Below is the Cognos URL I have given: https://cognosnext.bi.ibmcloud.com/bi/

Let me know your thoughts on same: Do Advise..

Regards
Cognos BI
2
Hello All,

I have created a Dashboard using IBM Cognos Analytics on Cloud/Web. Now for Predictive Modelling I need to integrate with IBM SPSS Modeler Subscription
I am trying to use IBM Cognos Analytics as Source from Source Tab: Clicked on Connection: Edit. After entering the Cognos Server URL its producing an Error:
It says: Failed Connected to Cognos Analytics Server.:

Do we need to enter any port number or any other path in Cognos Server URL
Below is the Cognos URL I have given: https://cognosnext.bi.ibmcloud.com/bi/

Let me know your thoughts on same: Do Advise..

Regards
Cognos BI

3
Reporting / Re: Value Prompt - Select All & Deselect All Option
« Last post by MFGF on Today at 03:26:50 am »
Team,

Here is my Requirement. Please let me know if there is a way to implement this.

1) I have a value prompt which is Single Selection
2) I changed the Select UI to List Box
3) Auto Submit Property is set to "Yes" to filter the records in the List based on the selection.
5) Run with Full Interactive mode is "Yes"
6) when the user run the report and when he select a value in the prompt, the records in the List will get filtered. Which is fine.
7) Now user changed his mind to deselect the option and see for OverAll values. So I need the Deselect option for List Box - Single Selection Prompt.

Thanks!
Kiran

Hi,

Add a Static Choice to the prompt of a single value - All
Then modify the filter from [Your list item] = ?Your Parameter? to [Your list item] = ?Your Parameter? or 'All' = ?Your Parameter'

This will give you an extra entry in your prompt for 'All' which will return all rows

Cheers!

MF.
4
A related Q. Why don't I see all the Account parameters visible in Cognos Configuration in the FWM model under Project - Session Parameters?

Another Q. How do I know when to use the format #account.<parameter> vs $account.parameters.<parameter> vs $account.personalInfo.<parameter>?

5
The IBM How to page is a little unclear. It should read something like "In the XXX - Namspace - Resource Properties window, click in the Value column for Custom properties under the Account mappings (Advanced) section and click the Edit button (pencil icon at far right of cell)."

Q. Do we need at add this new variable in the FMW model under Project - Session Properties?





6
COGNOS ReportNet / Re: Accessing attributes on LDAP
« Last post by Blue on 11 Dec 2017 06:12:26 pm »
1. yes, if documented in LDAP and parameters made available in Cognos Configuration
2. no, you can only modify AD properties though an AD UI.
7
Reporting / Value Prompt - Select All & Deselect All Option
« Last post by Kiran Kandavalli on 11 Dec 2017 11:19:01 am »
Team,

Here is my Requirement. Please let me know if there is a way to implement this.

1) I have a value prompt which is Single Selection
2) I changed the Select UI to List Box
3) Auto Submit Property is set to "Yes" to filter the records in the List based on the selection.
5) Run with Full Interactive mode is "Yes"
6) when the user run the report and when he select a value in the prompt, the records in the List will get filtered. Which is fine.
7) Now user changed his mind to deselect the option and see for OverAll values. So I need the Deselect option for List Box - Single Selection Prompt.

Thanks!
Kiran
8
Thank you MF!

I wanted to inform you that I may convert this report to a Report Studio Report. Seems like most of the prompts are single selection and by using Auto submit Property the user may get a feel of Active Report :).

The Crosstab filtering will be handled in just a filer condition.

I am attaching the info of the Active Report, so you may suggest me if there is any other best approach.

9
Hi MFGF,

Thanks for your reply. We are using the native client. We have connections for oracle databases and Exadata oracle. Connections to only Exadata databases are not working and getting above mentioned errors. However connections for both the getting tested with success on Cognos portal.

Thanks,
Cognoslearner1
10
Hey Folks,
Each of our named users in our deployment has their own database signon, which allows for scoping of data to get them just what they need to see when they run reports.

We have one report however that our requirement is to run it a different DB signon which has no scoping and shows all data (Global Signon).

I've run into some issues when trying to get this working so that it only is applied to a specified report.  In order for the users to view the report with the Global signon I need to allow them to run it, but then when they run any other report they are given the option of running it as this global view?  We need it for just a single report.

I feel my answer may lie in the run options (with user's credentials, with owner capabilities or "As User X") but it still seems that I need to allow the user access to the global signon with any of these options which then gives them the option to run any report that way.

Hopefully this is clear and someone has an idea for us!

Thanks!
Pages: [1] 2 3 ... 10

       
Twittear