Search results for query: *

Think I came across the API in question while googeling for a solution. Seemed a bit extravagant for a simple row count so I didn't even try it. Declare Function GetPrivateProfileString Lib "Kernel" Alias "GetPrivateProfileString" (ByVal lpApplicationName$, _ ByVal lpKeyName As Any, ByVal...

thank you drlex. This works well. I'm just amazed there's no simple macro command for this.

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...

Thanks to you both for the help. Checking the "move" box did the trick. And sorry for that double post. I wanted to rephrase my question and couldnt delete the old one.

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...

thanks for the help Fester but someone on a different forum pointed me towards the answer. It appears Auto_open macros never work when you open the excel file from a VB(A) script. Instead you have to hard code the running of the macro. I got it to work by adding this line to my script...

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...

pfft I keep messing up these abbreviations. I mean XML with XSL not XLM with XLS. Anyway I've found out why I couldn't view the XML properly. You're supposed to download and install the MSXML parser first. Thanks anyway.

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.

thanks for the tip drlex. I've looked up "dimension views" in Transformer help and I'm sure this is what I'm looking for.

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 retrieving well over 100 rows of data. Why would that cause an error? I'm using an Oracle database. I've somehow stopped the error from occuring. It may have something to do with the joins in the catalog underlying the .iqd files? Thanks for that tip on datatypes DoubleD. I'm sure it'll...

Forgot to mention there are no error message when viewing the data (IQD) in Impromptu.

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...