Recent Posts

Pages: [1] 2 3 ... 10
1
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>?

2
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?





3
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.
4
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
5
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.

6
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
7
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!
8
Cognos Administration / Re: Cognos 10.2 with Office 365
« Last post by Dhruv on 11 Dec 2017 05:52:03 am »
Hello,

It should work with Cognos 10.2 however you have to use relay SMTP for office365 or another way is to import office365 digital certificate into JRE. Both the way it would work.


Regards,
Dhruv
9
Hi,

When i run the reports i am getting below error message.

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-201'. UDA-SQL-0107 A general exception has occurred during the operation "columns". ORA-00942: table or view does not exist UDA-SQL-0196 The table or view "AGBPLDG"

Thanks,

The error message is telling you that you are trying to report on a table that does not exist in the database. Perhaps the connection information for the data source is incorrect (e.g., pointing to the wrong database or connecting with a signon that does not have privilege to the necessary tables).
10
Hi,

When i run the reports i am getting below error message.

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-201'. UDA-SQL-0107 A general exception has occurred during the operation "columns". ORA-00942: table or view does not exist UDA-SQL-0196 The table or view "AGBPLDG"

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

       
Twittear