![]() ![]() So how can we use this in Cognos? A prompt macro with a split and join works wonders. That would create a list with 3 rows, Scenario 1-3. Values() let’s us define a set, sort of like a union query. How can we get the query to have the rows? Turns out there’s a really easy way.Ĭognos SQL is based on the SQL-92 standard, which gives us a few very nice features. The values don’t exist in a table, so a simple filter won’t work. A developer wants to populate a query set using a prompt.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |