I have a simple query 'select * from fact where ...'. The fact table has a primary index and loaded with several batch of data files in appending way. When I run the query, the result is not ordered by the index. Why? I added ORDER BY in the query and all is fine. But I do like to know how does...
I read about Impromptu is being replaced by ReportNet. I have a few questions and hope you can share your thought or fact. 1)When do you think Cognos will stop developing Impromptu? 2)When will Cognos drop Impromptu support? 3) Same questions for PowerPlay for Windows. Thanks!
I used PowerPlay for Windows to create a crosstab report with for example, prodct line/product across all measures. The prodcct line/product is a defined 'subset' from the All Product dimension. I saved the report as 'Microsoft Excel Workbook' for a user who does not have PowerPlay. My problem...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.