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

#91
Reporting / Change default source of repor...
Last post by MrKlar - 04 Oct 2024 05:37:44 AM
All (data) sources used in a report are listed in the "Report" tab. The default source is indicated with a little red star.
Is there a way to change the default data source within the reporting tool or is this just possible by editing the XML?
#92
SDK / Rerun Failed Task
Last post by valentin - 03 Oct 2024 10:48:36 AM
Hi Team,

I'm writing a program to run a job with the SDK, check the status and retry if there's an error.

//LAUNCH JOB
SearchPathSingleObject searchPathSingle = new SearchPathSingleObject("/content/folder[@name='XXX']/folder[@name='XXX']/jobDefinition[@name='JOB_XX']");
Option[] runOptions = new Option[0];
ParameterValue[] parameterValues = new ParameterValue[0];
AsynchReply asynchReplyRes = test.connectionSrc.getJobService().run(searchPathSingle, parameterValues, runOptions);

//GET EVENT ID
AsynchDetailEventID eventID =  (AsynchDetailEventID) asynchReplyRes.getDetails()[0];

//Relaunch on Error
SearchPathSingleObject relaunchPath= new SearchPathSingleObject("/content/folder[@name='XXX']/folder[@name='XXX']/jobDefinition[@name='JOB_XX']/history[@eventID='"+eventID+"']");
AsynchOptionSearchPathSingleObject relaunchOption = new AsynchOptionSearchPathSingleObject(AsynchOptionEnum.restartHistoryLocation,relaunchPath);

// add restartHistoryLocation to Option
Option[] runOptionsRelaunch = new AsynchOption[]{relaunchOption };
AsynchReply asynchReplyResRelaunch = test.connectionSrc.getMonitorService().run(searchPathSingle,parameterValues,runOptionsRelaunch);

But I get the following error on retry

com.cognos.monitor.tse.TSEException: java.lang.NullPointerException

Can you help me with the restart?

Thanks
Valentin
#93
Administration and Security / Re: Cognos 11.2 LTS
Last post by dmusson17 - 02 Oct 2024 03:11:59 PM
Per this product lifecycle doc from IBM, 11.2.x should be supported through May of 2025.
#94
Reporting / Re: Navigation path in datamod...
Last post by MFGF - 02 Oct 2024 07:03:23 AM
Quote from: bergsorensen on 02 Oct 2024 02:52:51 AMFirst :)

We have all our excisting models in Framework Manager, and atm. no ressourcer to move this to a datamodules setup.

Though the navigation paths functionality in datamodules is very interesting.

Is there a similar functionlality in FM?

Thanks
Kasper

Hi,

Navigation Paths in a Data Module are similar to Regular Dimensions in Framework Manager, in that they provide a set of logical steps to "drill down" and "drill up" through levels of data. With Regular Dimensions you'd also need to define Measure Dimensions in FM, though, and the resultant reporting style would be different - your FM package would emulate an OLAP cube rather than a relational set of data.

Cheers!

MF.
#95
Reporting / Navigation path in datamodules
Last post by bergsorensen - 02 Oct 2024 02:52:51 AM
First :)

We have all our excisting models in Framework Manager, and atm. no ressourcer to move this to a datamodules setup.

Though the navigation paths functionality in datamodules is very interesting.

Is there a similar functionlality in FM?

Thanks
Kasper
#96
Administration and Security / Disable vs Suspend
Last post by cfsindorf - 01 Oct 2024 05:10:27 PM
We have a lot of scheduled reports and jobs. If we go into upcoming activities and select a day then select all of those and suspend them till a week later at 11:59PM will they all run at 1159 PM or will they turn back on and see if its time to run? I am worried they will all RUN at that day and time no matter the schedule. If I go to schedule I can select all schedules and disable then enable them later and they will run that schedule as defined. Someone told me the suspend just suspends that day and that time till later when it then runs it that time then it falls back into correct day and time.
#97
Reporting / Using value from macro in repo...
Last post by MrKlar - 01 Oct 2024 09:46:56 AM
Hi there,

is there a way to get the return value of a macro expression (CSVIdentityNameList) into a variable of a report? I would like to hide or show certain report assets based on membership of a particular group of the session user.

I've tried with prompt macro + default value but I failed managing to skip the prompt to the user and forcing the default value to be the prompt value.

Thank you for the reply.
#98
Reporting / Re: Macro Functions: Convert C...
Last post by MrKlar - 01 Oct 2024 09:41:23 AM
Quote from: MFGF on 01 Oct 2024 09:26:23 AMjoin('',
grep('System Admin',CSVIdentityNameList())
)
#

MF.

Hi MF, thank your for the quick reply.

However, if I use your above macro code, I get the following error:
Argument type 2 of function 'grep' is: string, but the required type is: array.

That is why I was posting the question, wondering what data type CSVIdentityNameList() actually returns.

However with a split function inbetween and douple pipes (||) the conversion to an array seems to work, at least for me:

# join(','; grep('System Admin'; split('||';CSVIdentityNameList('||')) ) ) #

#99
Reporting / Re: Macro Functions: Convert C...
Last post by MFGF - 01 Oct 2024 09:26:23 AM
Quote from: MrKlar on 01 Oct 2024 08:31:43 AMHi there,

CSVIdentityNameList() gives me back comma separated values. How do you convert that into a macro to be able to make use of grep() function to be able to search for a certain value?

Thank you very much.

Hi,

CSVIdentityNameList() is a macro function - you can only use it in a macro. Anything within hashes is classed as a macro, so #CSVIdentityNameList()# is a very short macro that returns your comma delimited list of account name, groups and roles. You can use any other macro syntax within the hashes, also, so you could add in your grep command

#
join('',
grep('System Admin',CSVIdentityNameList())
)
#

Not sure what you're trying to achieve? CSVIdentityNameList() returns an array of strings, which may or may not be what you need?

Cheers!

MF.
#100
Reporting / Macro Functions: Convert CSVId...
Last post by MrKlar - 01 Oct 2024 08:31:43 AM
Hi there,

CSVIdentityNameList() gives me back comma separated values. How do you convert that into a macro to be able to make use of grep() function to be able to search for a certain value?

Thank you very much.