Thanks MF.  Followup question . . . I was told that I should try a reporting drop-down with 'Crosstab' or 'list', then when the 'list' is selected, the layout just reflects that and will export out a clean csv file.'

I don't think that is a solution . . . is it?

It was great to meet everyone. 

What did you love?  What did you learn?  What do we need to do to get ready for Orlando next year?

Quote from: sarahelbokhari on 26 Oct 2024 01:48:23 AMHi,

I'm currently working on converting SAP OB reports to CA reports and would greatly appreciate your guidance on how to import a BO Universe into Framework Manager as a package to get started. I've searched extensively but haven't found relevant documentation. Could you provide some direction on how to begin this conversion? Thank you!

Hi,

I wrote that (what seems like) a lifetime ago! Things have moved on a lot with Cognos Analytics in the meantime. Since I wrote that, one of the various features removed from the product was the Meta Integration Model Bridge (MIMB). This was the component Framework Manager used to extract metadata from third-party sources, including SAP BO. If you are on any modern version of Cognos Analytics, you won't see an option to import third-party metadata. Interestingly, the 11.2.0 documentation still mentions importing third-party metadata sources, but when you click on the link, it takes you to a page that says "We're sorry! Content not found". It isn't there in the 11.1.0 documentation, so I suspect it's just a documentation error that it's there at all.
https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=sources-importing-metadata
In summary, the feature is deprecated, sorry.

Cheers!

MF.

Quote from: MFGF on 02 Aug 2018 02:24:02 AMHi,

BO reports and Cognos Analytics reports are different technologies. There is no mechanism to take a BO report and convert it into a Cognos report, unfortunately. You can import a BO Universe into Framework Manager to give you a head start on your package/s, but even then you will have a huge task in taking the imported content and re-modelling it to deliver accurate, consistent results (there are some fundamental differences in the way the two products generate queries).

For the reports, the best you can do is to use the original reports as a guideline for how your CA reports should work. Having said that, often you'll find that existing reports are not really relevant in many cases because the business has evolved since they were written, so really you'll be going back to first principles and doing analysis with the business on what their current requirements are.

Cheers!

MF.

Hi,

I'm currently working on converting SAP OB reports to CA reports and would greatly appreciate your guidance on how to import a BO Universe into Framework Manager as a package to get started. I've searched extensively but haven't found relevant documentation. Could you provide some direction on how to begin this conversion? Thank you!

Quote from: RunningBear on 24 Oct 2024 05:10:12 PMFirst-Timer with a post . . . I've inherited a report (11.6) that produces a cross-tab report (using 9 filters) from a data package.

The filter values (selected by the user), are displayed in the HTML as well as exported when the user selects 'Excel' as the output.

I need to modify the report to allow for csv output.  The problem is . . . I don't know how to include the filter selections within the csv output file.  Any suggestions will TOTALLY be accepted.

Hi,

Using the csv rendering option is only ever going to give you data - none of the layout from your report will be included. Also, if your report has multiple queries, the csv rendering option will only give you the data from the first query - I remember being caught out by this many (many) years ago. It's the same story with the 'Excel data' rendering option, too. The closest you can get would be to use the 'Excel' rendering option, but this obviously isn't a csv.

Cheers!

MF.

First-Timer with a post . . . I've inherited a report (11.6) that produces a cross-tab report (using 9 filters) from a data package.

The filter values (selected by the user), are displayed in the HTML as well as exported when the user selects 'Excel' as the output.

I need to modify the report to allow for csv output.  The problem is . . . I don't know how to include the filter selections within the csv output file.  Any suggestions will TOTALLY be accepted.

Quote from: dougp on 23 Oct 2024 07:20:48 PMI have been using SSL in Cognos Analytics for years.  I have a recipe that hasn't failed for years.  For some reason today in my dev environment...

I had CA11.2.4FP3 installed on the server, and the server has been powered off for months.  It was running using http:.  I brought it up and ran through my SSL instructions today, which includes stopping and starting CA at key points in the process.  But when I try to start the service I see:

Code Select Expand

[Launching a JVM using 'Maximum memory in MB']
[ ERROR ] Failed to launch a test JVM with the current memory setting.
Details from the JVM :
The system cannot find the path specified.

I'm not finding relevant help for this online.  The message is vague enough that I'm not even sure which logs at what location to inspect or which configuration files to look at... or if I made a mistake in Cognos Configuration.

...and this doesn't feel like it's directly related to implementing SSL.

Any pointers are appreciated.

Quick sanity check - are you using the default IBM java runtime that ships with CA, or are you using a different one (Oracle?). Have you checked the environment variables to see where the system is looking for the java libraries - and that they exist in that location?

Cheers!

MF.

I have been using SSL in Cognos Analytics for years.  I have a recipe that hasn't failed for years.  For some reason today in my dev environment...

I had CA11.2.4FP3 installed on the server, and the server has been powered off for months.  It was running using http:.  I brought it up and ran through my SSL instructions today, which includes stopping and starting CA at key points in the process.  But when I try to start the service I see:

[Launching a JVM using 'Maximum memory in MB']
[ ERROR ] Failed to launch a test JVM with the current memory setting.
Details from the JVM :
The system cannot find the path specified.

I'm not finding relevant help for this online.  The message is vague enough that I'm not even sure which logs at what location to inspect or which configuration files to look at... or if I made a mistake in Cognos Configuration.

...and this doesn't feel like it's directly related to implementing SSL.

Any pointers are appreciated.

Quote from: jsibley on 22 Oct 2024 02:54:22 PMI've also learned that it will merge them together if there are no nulls, but when there is a null then it gives me nothing.  So if 3 out of the 4 competencies have values and I don't ask it to add the 4th competency it works, but when I add in the last one, that does have a null, it gives nothing.

Re the nulls, that would be expected behaviour - a null denotes an unknown value. You'll need to replace the nulls or check for them in your expression.

Cheers!

MF.

I've also learned that it will merge them together if there are no nulls, but when there is a null then it gives me nothing.  So if 3 out of the 4 competencies have values and I don't ask it to add the 4th competency it works, but when I add in the last one, that does have a null, it gives nothing.