Search results for query: *

Hello Can someone please explain how currency symbols are displayed in powerplay. After I build the cubes, and open them in powerplay on the Cognos server they correctly display in Euros. However, when the cubes is opened on another client, currency values show UK Pounds. Is there a setting...

Thanks guys, I managed to perform a test and it works great.. sub main Dim lsCommand As String lsCommand=Command$ cmdlen = Len(lsCommand) if cmdlen = 0 then MsgBox "cmdlen=0; Exiting" Exit sub End if MsgBox(lsCommand) End Sub Here is the format that should be used...

Hello Is it possible to pass parameters into a macro from a batch file (.bat) I would like to be able to pass strings such as catalog names, folder names etc. to reduce the number of macros that I need to maintain as these items are currently hard coded within each macro. Thanks

Here it is, it does a little more than just the Excel generation. '------------------------------------------------------ ' Macro to build PowerPlay Cubes '------------------------------------------------------ '...

Thanks for that, I didn't want to limit all data sources, just the source for the primary transactional data. The other data sources are for descriptive data only, I guess I can ensure that the limit is changed to ensure all descriptions are loaded. Thanks again!!

What is the SQL syntax to limit the number of rows read from the database in an IQD? Can someone please post an example. I want to do this to test that the structure of the cubes look OK before building a cube full of data. Thanks in advance.

Thanks drlex, this works very well. A lot more resilient. ' Save as Excel 2000 Set ImpExcelRep = objImpRep.PublishExcel ImpExcelRep.Version 0 ImpExcelRep.ExportOptions 0 ImpExcelRep.Publish saveExl$

Hi I have a Macro that reads the content of a directory full of *imr's and creates Excel with Format output. The basic process works fine until there is a formatting error. The Macro hangs on this statement.. objImpRep.ExportExcelWithFormat saveExl$ when run interactively, there would...