Only 3 of the data sources are structural; the rest are transactional. However, 9 of the 16 dimensions are one-level dimensions. Not sure what you mean by record count, the number of records in the data sources? No category count measures and only 2 calculated measures (out of 28). Cube size...
There are 16 dimensions and 70 data sources in the model. The counts are 4818, 16, 14942, 27762, 31, 80, 54, 15858, 128, 2063, 2079, 4, 188, 12329, 29558, and 981. As you can seem none are in the 100ks.
Hello,
One of our cube updates is taking an extraordinarily long time in the "Updating the Powercube metadata" step. It's taking 3 hours for just that step! Prior to this weekend the entire cube update took about 2 3/4 hours, now it takes 5 1/2 hours. As far as I know, nothing changed in the...
Hi,
I found the solution to this problem. For anyone else who may have this same issue, if you look in the Properties of the PowerCube under the Processing tab. The Optimization drop-down selection had said "Categories". I changed it to the "Default (auto-partition)" selection, reran the cube...
Hi,
I am using the "automatically set the current time period" feature in PowerPlay Transformer 7.0. I have one of my data sources checked to "Sets the current period". The other data sources have this box unchecked. When I generate the cube by opening the model and clicking the "Create...
I have tried re-generating the categories several times. They always come out in the incorrect order in the cube even though the diagram in the model has them ordered correctly.
I have a CognosScript macro (which I obtained from this forum) that is creating an email message in Outlook and attempting to send it. Before the message can be sent, Outlook is sending a prompt asking if it is OK to send the email. How do I automatically respond to the prompt in the script...
Using Cognos Transformer 7.0, I am using multiple sources in a particular model. The resulting cube has the categories in several of the dimensions not in the proper sequence even though I have specified the order in the "Order By" tab under Properties. The categories in the diagram of the...
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.