Welcome to the IBM TechXchange Community, a place to collaborate, share knowledge, & support one another in everyday challenges. Connect with your fellow members through forums, blogs, files, & face-to-face networking.
Join / sign up
Hi Marc, you cannot use Cognos data items between ( ). All elements have to be named like in the native tables like you wold have written manually in SQL. I've never used these kind of Oracle functions ...
@NIGEL CAMPBELL Thanks for the link. But I have run out of talent in trying to get CA to use Oracles Linear Regression Functions. For example, let's say I have a query with [Product Line], [Month] and ...
Hello, Why SSO is not working ? It is a huge question that cannot easily answered. Did you use the IIS script provided with the installed version? What kind of delegation are you using (Constrained, ...
ISO-SQL defines functions which may not include a window specification. Dynamic Query provides both a built-in implementation of the ISO-SQL regression aggregates (non-Windowed), it will push them to ...
I've already created a calendar style report using repeaters but my question is if it's possible to display events that are multi-day... for example something to look like the screenshot below: ...
Installed IBM Cognos Analytics 12.0.2 and configured it for SSO (single sign on). When URL http://iis-host/ibmcognos/. is opened in Chrome i am prompted with the message "your connection to site is not ...
Thanks Ralf! This is very cool and I will definitely be attending your webinar! In my case I have verified I can authenticate and query the API using scripting, however I am hoping I can build a config ...
Hi Marc, Did you try double braces (( )) rather than single braces? If memory serves, single braces denote Native SQL and double braces denote Pass-Thru SQL. There might still be some query engine ...
From my understanding StatsByCube can, in many cases be inaccurate so it would be good see what debug says. ------------------------------ Ryan Clapp ------------------------------
Hi Ryan, thank you for answer & hints. I will try to briefly answer your questions. Have you tried to use bookmark files to better manage the cube load times at start up? Not yet. I am only aware ...
Hi Stuart, Thank you for your response! Great, that sounds exactly like what we've been looking for. Hopefully, these features will make it into the product soon. :-) ------------------------------ ...
Hi Mario, Happy to confirm we are tracking work items to customize those cells (set the color, border lines, etc). I typically refer to these cell as headers for row and column headers, I've also heard ...
Anytime you multi-thread an operation more RAM is required, combine that with the v11 memory allocator and you can certainly have significant growth in the memory baseline. A few questions come to mind ...
Hi Robert. I tried the old () trick before remembering aggregate: In the most simple form of the function ( REGR_SLOPE( [Revenue], [Year] ) ) fails with ORA-00936: missing expression, whilst aggregate:REGR_SLOPE( ...
Hi Marc, have you tried to bypass pure SQL code into the generated code by using ()? Everything between ( and ) gets send 1:1 to the database and is not interpreted by Cognos. I use this trick to sqeeze ...
Hello to all! Does anybody know, are there any shortcuts to use with IBM spreadsheet services (like recalculate, send back data). Thanks a lot. Andreas ------------------------------ Andreas Schuster ...
Hello, Through an IBM support ticket, my gut feeling was confirmed. Chores run on UTC, not local time. This has implications for potentially all chores and the upcoming Easter weekend we might face ...
Hello to all! Is there any option/settings to disable/turn-off the undo/redo icons buttons in the toolbar (resp. the function)? Thanks a lot! Andreas ------------------------------ Andreas Schuster ...
Hello to all! Is there any option/settings to avoid re-opening a PA spreadsheet service report/view (many reports with same name, report should be opened just once) so that I don't find myself in a lot ...
Hi All, I am writing a report in which I want to use oracle's linear regression functions. I know I can use the AGGREGATE: trick to get the report to pass these functions through as summary calculations. ...
Hi Laurent & John, thx for the inputs. @Laurent: unfavourable news, but at least we are not the only one facing this issue. I created a ticket regarding this behaviour. keep you updated in this thread ...
Re: Feederless engine. It was said on the Jan or Feb AMA that this is scheduled for TM1 Server 14. So don't plan for that as the answer ------------------------------ John O'Leary ----------------- ...
Hello Bernhard, Same here, we've been testing this since it appeared and the results are completely inconsistent, which is unfortunate because it allows to start way faster when handling big feeders. ...
Hello Cognoids, We are using the custommizedTabFeature and would like to offer two different languages so, "Public Folders" and "Inhalte". I guess this has been asked a couple of times before? Searching ...
Hello @Guillem Labòria Soto, we have been using Cognos SDK to add users to groups based on XML file: See source code: https://github.com/AMVARA-CONSULTING/cocoma It uses java and runs on command ...