- Home
- Database
- Reporting
- Cognos PowerPlay
- Cognos Powerplay - 2009 date issue
|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
Cognos Powerplay - 2009 date issue
Asked by kevin1983 in Cognos PowerPlay, Data Mining, SQL Query Syntax
We are using Cognos Powerplay version 6.61 along with Cognos Powerplay transformer to build powercubes which are built using data from an access database. The problem is the dates for 2009 are not showing correctly, it seems that data is showing one week ahead of schedule during 2009. i.e. there was sales data showing under week beginning Monday the 12/01/09 last week when at the time we hadnt even begun
that week yet and did not have any data within access that falls under that week (12/01/09 to 18/01/09), also this week should begin Monday 12/01/09 but data for this week is instead showing under next week which doesnt start until Monday 19/01/09.
It appears that week beginning Monday 05/01/09 is missing both in Cognos Powerplay and Cognos Powerplay transformer.
If its possible to add a week into the transformer then this could fix the problem but i cant find a way of doing this.
Maybe its because of the way the dates are for 2009 are different from 2008 and it has put the system out of sync. Our weeks are based on a 12 period year, with a 4,4,5 week using a lunar year. Cognos Powerplay transformer gets its data from a query within a Microsoft access 2003 database
Ive tried to re-generate the categories again but still the same issue.
Does anyone have any ideas on how I could fix this?
Advertisement
| Hall of Fame |
- 1. RWrigley19,697
- 2. twlarsen13,750
- 3. welchb1234,094
- 4. mlmcc2,500
- 5. capricorn12,000
- 5. burrcm2,000
- 5. boag20002,000
- 5. OnALearn...2,000
- 5. mwvisa12,000
- 5. momi_sa...2,000
- 5. zelron222,000
- 5. moozekips2,000
- 13. adamy1,500
- 13. Kdo1,500
- 13. suppsaws1,500
- 13. tercex111,500
- 17. rrjegan171,250
- 18. ssam1,040
- 19. janicet1231,000
- 20. schwertner672
- 21. it-rex200
- 22. garycris164
- 22. ikori164
- 24. abbasiftt150
- 25. bhermer100
- 1. RWrigley104,157
- 2. welchb12322,294
- 3. twlarsen13,750
- 4. nmcdermaid7,164
- 5. mlmcc5,984
- 6. simon_kirk5,320
- 7. emoreau4,450
- 8. oleggold4,000
- 9. dtodd3,000
- 10. adamy2,920
- 11. Kdo2,500
- 12. burrcm2,060
- 13. SysExpert2,000
- 13. capricorn12,000
- 13. allanau202,000
- 13. ged3252,000
- 13. bhaskarss2,000
- 13. rherguth2,000
- 13. arbert2,000
- 13. boag20002,000
- 13. OnALearn...2,000
- 13. jogos2,000
- 13. mwvisa12,000
- 13. GJParker2,000
- 13. momi_sa...2,000
- 13. ibrusett2,000
- 13. Cedric_D2,000
- 13. zelron222,000
- 13. moozekips2,000
