Search results for query: *

User Need : We wish to set the extraction of data from a table based on filter statements expressed by an administrator in a flat file. Constraints : The number of filter statements is not fixed. There is at least one filter statement. The format of this flat file is fixed. Flat file filter...

Here is a solution recommended by IBM : http://www-01.ibm.com/support/docview.wss?uid=swg21341806 To get the list of parameters coming (PromptName) from the prompt in the SQL Statement, you have to call the prompt via a macro : #prompt('PromptName')# Example : SELECT Field1, Filed 2 FROM...

Hi everybody, I'm looking for the way to filter a report with the REGEXP_LIKE oracle function implemented with a list of patameters coming from a prompt My problem is : To use the REGEXP_LIKE function, I have to "protect" the filter expression by "{" (example ...

Hi all, Sorry to ask that. How to align two columns of differents cross tab ? Regards.

Hello all, Is it possible to add sum of column or line in a cross tab. If yes, could you explain me how to do ? Is it possible to filter the data included in this sum, for example: Enterprise ProductType Sept Oct Atelier1 toto 1 5 Atelier1 tata...

I've just imported data in oracle schema, but the creation of an oracle connection via SQL Net to this schema (congnos connection) doesn't work.

Hi, I'm testing C8 on my own personnal computer. I've installed Oracle 10g Express Edition and C8 server and deploy the "Content Store" of C8 in the SID = XE schema C8 without problem. Now, I would like to connect to one schema samples data (gosl), which I imported in Oracle 10 G, with cognos...

Is Powerplay able to make requests between cube from "Transformer" and/or resulting from other cubes (Essbase, DB2OLAP)?

Does Powerplay manage internally "slowly changing dimension" ? Thanks for your answers.

Hello everybody, In the module transformer V7.0, I try to define a dimension date from a date field (DD/MM/YYYY) resulting from my iqd file. I use the function "date wizard". The category "week" brings back the first day of the week but I will wish to have the number of week (1-52). How to...

Hi everybody, My company sold to me as a powerplay expert which is not thrue of course. So would you please send me documentation/site about how to load cube and/or tips about what to do and not to do to load a cube? I think that the reporting part is less difficult to ...improvise but you have...