If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Creating a Data Item

Started by Modtamod, 28 Jan 2008 11:03:20 AM

Previous topic - Next topic

Modtamod

I need to create a data item that have values not related to any of my other data items or queries? Basically the value that I want is 0 up to 36 that is shown only on 1 column .It will look like this when I query it....

0
1
2
3
4
5
6
7
8
9
10
...
...
..
...
36

Please help me with the syntax or how I can accomplish this.

almeids

If it's truly unrelated (i.e. you can't use running-count), you can...
...add a table with what you need to your database and package, or
...create a 36-part union in RS, each of which selects a static value from your database's pseudotable (e.g. DUAL in Oracle), or
...use running-count in a query from an unrelated table for which you can formulate a filter which will guarantee 36 rows returned.

Bottom line is it has to come from the db, either all at once or in pieces.  If anyone knows how to do it from thin air please correct me, it would be very useful to know!