If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Recent posts

#1
Framework Manager / Re: Macro to change Databases
Last post by bus_pass_man - Today at 05:21:13 AM
You can use macros.

#2
Framework Manager / Re: Macro to change Databases
Last post by cognostechie - Yesterday at 07:29:10 PM
I don't exactly know what you mean by Data Source connection property. Are you referring to the connection of the Data Source in Cognos admin page or Data Source properties in FM? Both are different things. The Data Source object in FM is a local Data Source embedded inside the xml file which connects to the actual Data Source using the properties defined.

It is working now. The problem was the model was brand new so it was using DQM mode. It doesn't work in DQM models. When I made a CQM model, it worked. To double check it, I also converted the new DQM model to CQM and it worked! Seems like they disabled it for DQM models.
#3
Administration and Security / Re: Cognos 11.0.1: Users Unabl...
Last post by delawless - Yesterday at 10:20:03 AM
Gunny,

We had the same issue occur with us and found this to be related to a Web application firewall rule (external to cognos itself) that was preventing http delete actions from reaching cognos when the corporate CDN was used, vs logging into cognos directly (via port 9300) which allowed for "My Content" owned-object deletion by users.

 
#4
Framework Manager / Re: Macro to change Databases
Last post by bus_pass_man - Yesterday at 04:43:32 AM
I'm assuming that you consciously made the decision to not put the macro into the data source connection property and, instead, pursue this approach. Could you explain why that method was not suitable please. 
#5
Any free training material to use with VAI S2K?
#6
Framework Manager / Macro to change Databases
Last post by cognostechie - 07 Jul 2025 03:02:09 PM
I swear I have done this before and it used to work but somehow in ver 11.2 it doesn't work.

I want to change the Database depending on which Database the user wants to connect to so I created two Data Sources in Cognos and reports are working from both. Now I created a Model Query subject with two columns.

1> DS_ID  - Value is '1'
2> DS_NAME - CASE
    WHEN #prompt('Type NewDB or LegacyDB','string')#  = 'LegacyDB' THEN 'LEGACYDB'
    ELSE 'NEWDB'
  END

LEGACY and NEWDB are the Data Sources in Cognos.

I created a Parameter Map with the name DS_NAME and pointed that to the Model Query Subject. DS_ID as the Key and DS_NAME as the Value.

In the Data Source , property - Content Manager Datasource - I am putting this #$[DS_NAME]{'DS_ID'}#

It gives an error 'QE-DEF-0286 Unable to find the connection #$[DS_NAME]{'DS_ID'}# in the Content Store'

What am I doing wrong?
#7
Reporting / Re: Active report error - anyo...
Last post by KETINU - 07 Jul 2025 07:45:28 AM
Quote from: MPritchard55 on 29 Jun 2023 01:08:32 PMNo parameters or filters in the report (other than the interactive filter data drop down for the Active report).  HOWEVER, we do have 3 instances of our db (test, dev, prod) that we get prompted to select one of them every time we run the report.  This is the case with every report.  So every time I schedule a report, I set the prompt to the Prod selection.  I did this when scheduling this report as well. 

Just to be clear....you can absolutely schedule an active report, correct?  It's also only giving me the option of scheduling it to an HTML and yet I could swear you could export it to Excel and still have the interactivity within the excel spreadsheet, no?

Hi ! i've got the same problem witj the scheduling, could you please tell me how did you fixed it ?
Thanks
#8
Framework Manager / Re: Creating e new framework p...
Last post by MFGF - 03 Jul 2025 06:00:13 PM
Quote from: Suarez on 19 Jun 2025 03:51:34 AMHi everybody, Cognos Version is 10.2
After a recovery/restore due to hw server fails we have a problem.
In the IBM content administration we see all the packages we had and the reports works
In the framework we don't have all the project we used to work on.
Is it possible to create a new project importing model data from an already published package?

Hi,

Yes, it's possible to do this, but bear in mind that the model you end up with will only contain what was published in the package.

Take a look at the below tech note for details on how to do this:

https://www.ibm.com/support/pages/how-recover-parts-corrupted-or-lost-framework-manager-model

Cheers!

MF.
#9
Hi,

I am new to Cognos. I have a bit of experience with Power BI and Tableau. Where would be a good place to independently study what Cognos can do for someone who will make reports? I am an EDI business analyst, and my goal is to move to various departments within the organization to do reporting from our ERP, connected to the tool.
#10
Reporting / Re: Parse string at last delim...
Last post by taifmali - 03 Jul 2025 02:06:53 AM
Quote from: Cogency on 20 May 2025 11:53:42 PMI've found a 3-step solution

1.    Reverse = reverse([String_Column])
2.    ParseReverse = substring([Reverse], 1, position(' ', [Reverse])-1)
3.    ReverseParseReverse = reverse([ParseReverse])

It's a bit long-winded but it works.

You can use it in one item:

reverse(substring(reverse([String_Column]), 1, position(' ', reverse([String_Column]))))