Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: TyClabbers
- Order by date
-
Problem with the data or me?
In report studio create three queries. Each query has the columns employee, type and number. The first query has a filter on type = 'Work', the second type = 'Work' and the third type = 'Mobile'. Then create a join (query 4) between query 1 and 2 linking on employee. Then create a join between...- TyClabbers
- Post #5
- Forum: Cognos solutions
-
[TR1901] A PowerCube Table or index is full
The best value for MultiFileCubeThreshold depends on the size of your input records. Small records will mean you can set the value much higher. You have to test some different values. If you set the value to high it is possible you will create mdp files that are larger then 2G. If you set it to...- TyClabbers
- Post #4
- Forum: Cognos solutions
-
[TR1901] A PowerCube Table or index is full
Use the parameter MultiFileCubeThreshold. This parameter sets the number of rows for one file (or something like that). You should test some different values. We use MultiFileCubeThreshold=7500000. This can be set in the ini file (so all cubes will be using this value) or as an input parameter...- TyClabbers
- Post #2
- Forum: Cognos solutions
