2012年9月8日 · There are huge differences between "Cognos TM1" & "Cognos 10 BI"! Cognos TM1 is a (OLAP) multidimensional database which can be queried from Excel and the Web through "TM1 Web", "TM1 Executive Viewer" and "Cognos 10 BI". Within this database, you'll be able to create almost anykind of OLAP / Decisional application. Cognos 10 BI is a web based …

I have two (so far) source cubes and their respective dimensions: EXPENSE: Date1, Date2, Supplier, Cost/Profit Center, Project, Type of Payment, Measures. INCOME ...

2016年4月18日 · 2.I am trying to load data from Tm1 Cube to Java, solve problem based on this data and then return data back. 1.No, it doesn't have to be REST API (but it has to be Java). Solution with pre-creating views works fine, but seems inconvenient to me. I need large number of such views, so I want to be able to create and delete views dynamically via API.

2020年2月26日 · I am trying to create a calculation in Cognos based on a number of Criteria. For example, I want to get a count of all of the records in my data set that have the following criteria: Data_Level = "

2023年6月23日 · There are 2 parts that are used for Cognos expressing a join The first part is either 0 or 1. 0 is outer, 1 for inner join The second part is the type of relationship either 1 or n for many You have 0.1 to 0.1 However the two tables I believe have data you want to treat as facts?

2017年6月22日 · So I ran into a similar issue myself when trying to remove the time element from a report i created. Unfortunately, the version of Cognos my company uses no longer has date available in data format under properties. To resolve the issue, I used Cast ( [Project Header]. [Project start date], date) to remove the time element. In inputted the cast element as part of …

I have a query expression in Cognos where I need to compare a past date to the current date. I don't see one in the functions list and I'm otherwise unsure how to put the query date inside a query object.

2015年12月20日 · In Cognos RS 10, I am trying to create multiple if statements but the report fails. The report works when I do not have this in as an expression. I want to create a field that shows days between ...

2015年3月30日 · when you use case you have to specify what to do when the requirement is met - not to give another condition. something like: case when [bla] = "foo" then "return_value" else "nothing" end remember -whatever you write in a calculated vlue in a data item is translated to sql, and that's precisely how it also goes in sql...

I do know that Cognos is sometimes excessively picky about the exact syntax of expressions. For instance, requiring an ELSE clause in an IF within a filter expression.