Recent Posts

Pages: [1] 2 3 ... 10
Reporting / Re: Expression to return last 6 months
« Last post by Cognos_Jan2017 on Today at 01:15:37 pm »
I have Authored only Relational Data, so we need a Dimension Person to help on this.
Hello MFGF,

I have installed the DB2 client on the COGNOS Server.

Reporting / Re: Expression to return last 6 months
« Last post by jway on Today at 12:39:22 pm »
We have other fields from the date dimension.  Date, MonthDayYearSlash, ShortMonthYear, etc.  In our dimension Month is in the format  YYYYMMDD, Date is: YYYY-MM-DD, ShortMonthYear is:  MAR 2018
Report Studio / Unable to connect to SQL Server in Report Studio
« Last post by Mfg on Today at 12:35:32 pm »

Cognos 10.2
Authentication: Microsoft Active Directory.

Created a data source to connect SQL Server using external namespace (MS Active directory) through OLEDB. The connection is getting succeeded when i try to test it.

But when i try to write a SQL in report studio using this data source, application gives me an error.

Please find the error below attachment

Do anybody have come across this issue. Please suggest.

Thanks in advance.
Data Modules / Re: MSR_GEN_0057 Failed to get module metadata
« Last post by bus_pass_man on Today at 12:18:26 pm »
My working hypothesis is that you've imported a deployment which does not have the include uploaded data setting on and / or you choose to Assign new IDs during import in the store IDs section. 

Problem 1. The module data source problem.

You've tried to open up a module. The module produced an error referring to some bloody long ID, which is essentially useless. Is that a correct understanding?

You say you are in R9. It should be possible to open a module even if the data sources are not available, so I think you are able to open the module.

You're over-complicating things and pursuing a chimera.  When you open a module, you are editing it.  You have everything which is in the module--the relationships, calculations etc. so your quest

Even if you had access to the specification of the module you'd have nothing more than what you already have.   

Even if you had the specification you couldn't do much with it and if you somehow managed to figure out a way to do something with it you'd probably be violating your license by reverse engineering etc.  and would have the IBM legal hellhounds on your tail.

Problem 2. The data source problem.

There are several possible reasons why you can't access the data sets.

They might be located in the former modeler's my contents.

They might not have permissions for you to read them.

They might not actually be there.

When you say you imported the modules, I'm assuming you are saying you were working with a deployment.  What type of deployment was it?  If you were working with a partial deployment, can you confirm if the include uploaded data setting was on when you imported the deployment.   Did you check on the folders in the public folder, directory and library content page?  Can you confirm what setting you choose for the Store IDs section.  Was it the default, generate new IDs or do not assign new IDs?

Try, in a fresh CM db, using the do not assign new IDs option.

In extremis upgrade to R10. 

It has exposed the folder path or the data source name and schema for the data sources used in the module.   

Press the add sources button in the sources pane.  It will display a list of the sources in the module and the folder path to them or the data source name and schema.

It also has a feature to relink the data source. 
Reporting / Re: Expression to return last 6 months
« Last post by Cognos_Jan2017 on Today at 12:00:48 pm »
[Customer Integration].[By Customer Integration Post Date].[Month] >= _add_months([MaxDate], -5)

Do you have another Field/ Data Item other than '[Month]'?

Something like ...
[Customer Integration].[By Customer Integration Post Date].[DateOfInterest]

HTH, Bob
Reporting / Expression to return last 6 months
« Last post by jway on Today at 11:47:33 am »
I'm having trouble coming up with an expression in a relational report to return the last 6 months' data. So basically the maximum data in the fact table and then the 5 months before.  I have a data item MaxDate that has the most recent month. Then I tried a filter expression:

[Customer Integration].[By Customer Integration Post Date].[Month] >= _add_months([MaxDate], -5)

But that's not appearing to have any effect on the data displayed in the report.  Any ideas on what i can do to get this working?

Since posting the above, and thinking about that last night, I know there are at least 2 other Legacy Visualization Combination Charts. Will try those to see if the "Vertical" can be done on at least one of them.

To Legacy Visualization Combination Charts ...
In Legacy Visualization Charts, trying the 1st Combination Chart of Type "vis.sample.combination" WORKS where Category Labels display Vertically.

IF anyone can figure out how the get the Topic Chart Category Labels to dsplay vertically, please let us know.

Thank you, Bob
Reporting / User Defined SQL - Reports cannot be scheduled
« Last post by Cognos91 on Today at 10:18:34 am »
We have custom reports, using pass-through SQL. Users can create these reports as well as run them manually. However, when they try to schedule these reports, they get the following error:

"RQP-DEF-0326 User defined SQL is not permitted for the user who has the identity '{Everyone, All Authenticated Users, Consumers, Mobile Users, Cognos Insight Users}'. "

I checked their permissions and it looks like they do have access to User Defined SQL capability. In addition, as noted in IBM, the BI package also has been granted the same capability.
We are unable to identify anything at this end.

Please do note that we control our security permissions via COgnos SDK.

Is there anything additional that needs to be looked into?
Reporting / Re: Crosstab Issue
« Last post by rwaugh on Today at 08:19:18 am »
Thanks for the reply MFGF!  I've attached a snippet of what my crosstab looks like at the moment.  Not sure if that will help or not.  I dragged the column that contains the Yes or No value into the cells of the crosstab.  I'm sure it's something simple that I am missing and can't for the life of me figure it out.
Pages: [1] 2 3 ... 10