Urgent Help

[karim19]

Hi all

I am generating 2 cubes but i have a problem. Instead of having values i'm getting '?' all over.

The first cube has been generated with no erros while the second had this one :

09/07/2003 00:35:17 4 0000028F Start Write leaving 86248 categories remaining.
09/07/2003 00:35:17 4 0008D331 Updating the PowerCube data.
09/07/2003 00:35:17 4 0008D331 Updating the PowerCube data.
09/07/2003 00:35:26 4 0008D331 Performing DataBase Commit at record number 220568.
09/07/2003 00:35:26 4 0000028F End Write leaving 86248 categories remaining..
09/07/2003 00:35:26 4 0008D331 Timing, CUBE UPDATE,00:00:46
09/07/2003 00:35:26 4 0008D331 Committing PowerCube(s).
09/07/2003 00:35:38 4 0008D331 Timing, CUBE COMMIT,00:00:12
09/07/2003 00:35:52 4 0008D331 End cube update.
09/07/2003 00:35:52 4 0008D331 Timing, TOTAL TIME (CREATE CUBE),01:15:52
09/07/2003 00:35:53 2 0008D331 (TR1901) The lowest level partitions must span full breadth of their dimension when user class security w/filters is in force. (Data) in d:\cognos\cube\sales.mdc. [->OK]
PowerPlay Transformer Wed Jul 09 00:35:55 2003

I guess that for the second it may concern the orphans in the database while i don't understand for the first why i'm getting '?' all over.

Thanks for your reply

 

[karim19]

Just forgot to mention that both cube files have the estimated size (almost 150 Mo)

This is the log for the first cube that seems to have no error but the display of '?'

08/07/2003 23:17:44 4 00031F4D Timing, CUBE UPDATE,00:13:20
08/07/2003 23:17:44 4 000005C7 --- Performing Pass 1 with 1998853 rows and 86247 categories remaining.
08/07/2003 23:17:44 4 000005C7 Selected Dimension 1 for next pass of partitioning.
08/07/2003 23:17:44 4 00031F4D Counting category hits.
08/07/2003 23:17:45 4 000005C7 End sorting 1998853 records.
08/07/2003 23:17:45 4 000005C7 Start Count and Consolidation with 1998853 rows and 86247 categories remaining.
08/07/2003 23:18:26 4 000005C7 End Count and Consolidation with 220567 rows and 86247 categories remaining.
08/07/2003 23:18:26 4 000005C7 Start Write leaving 86247 categories remaining.
08/07/2003 23:18:26 4 00031F4D Updating the PowerCube data.
08/07/2003 23:18:26 4 00031F4D Updating the PowerCube data.
08/07/2003 23:18:37 4 00031F4D Performing DataBase Commit at record number 220568.
08/07/2003 23:18:37 4 000005C7 End Write leaving 86247 categories remaining..
08/07/2003 23:18:37 4 00031F4D Timing, CUBE UPDATE,00:00:53
08/07/2003 23:18:37 4 00031F4D Committing PowerCube(s).
08/07/2003 23:19:00 4 00031F4D Timing, CUBE COMMIT,00:00:23
08/07/2003 23:19:15 4 00031F4D End cube update.
08/07/2003 23:19:15 4 00031F4D Timing, TOTAL TIME (CREATE CUBE),01:50:58
PowerPlay Transformer Tue Jul 08 23:19:19 2003

 

[karim19]

Any idea ?

Thanks

 

[CognosProfessional]

1. Test all of your .imr's if you are using .iqd's.
2. Open .mdl and modify columns of data source. Save .mdl.
3. Save as .pyi
4. Close .pyi
5. Open .mdl and build test cube.

Be sure your security is correct in the model/catalog.
Be sure your file locations are all correct.
Be sure your dimensions/allocations (colors) are checked.

CP

 

[benbotektips]

For the '??', check that u have the option to fetch data automatically, otherwise u have to tell Powerplay to do it.