Search results for query: *

Hi, I've spent the last hour trying to find out how this is done. There doesn't seem te be a simple way of doing it. I want to loop through all the rows in my report and stop when the last row is reached. For this I need to determine the number of rows in my report. for row = 1 to...

Is there a way to automatically remove all the categories in the model before the Cube is rebuilt? So far the only way I have found to do this is manually remove and re-add the levels from the dimension. I know you can disable the adding of new categories when the data source changes. But I...

I have a powerplay transformer cube that is rebuilt nightly. This normally goes without problems. Last night however the rebuild crashed with the error message "Uniqueness violation". It turned out the name of a staff member in one of my datasources was altered but the personal number didn't...

Hello, im using a VB script to launch an .xls (excel) file. This works fine except for one excel file that should run an Auto_open macro when launched. It does run perfectly when launched from the windows explorer but won't run when launched via the VB script. I can run the macro from the Excel...

I've got about 10 dimensions in my powercube (I know it's a lot but my users insist). When I drag dimensions into my rows and columns some dimensions hardly take any time to process but others can take 5 minutes. The cube is just 20MB and takes 5 minutes to create. I wouldnt mind if it got a lot...

Hello.. quick question here. Do I need something like IIS to view an xlm file with xsl formatting? I'm trying to view the xlm file in IE locally but it doesnt show any values. thanks.

In Transformer I would like to use a unique level to associate other levels in a dimension to my data sources. However this level is purely a unique productcode that is of no use to my end users. Is there a way to hide this level so that it won't show up in the Powerplay report? thanks.

I'm getting a mysterious error message while building a powercube. (see below). I'm trying to build a cube from a couple of IQD's. I know it's the IQD that shows some data on projects that's causing the problem. When I use a filter in Impromptu to show just a couple of projects and I save it in...

I want to create HTML reports from Powerplay. By using the "publish HTML" option in PP I get some very plain (horrible) looking reports. I also want to use some hyperlinks in the HTML to switch between reports. My question: how can I get more control over the way PP exports the report to HTML...