MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now Learn More
Quote from: Warm on 14 Mar 2025 10:45:59 AMThank you for the advice. We're using IBM Cognos Analytics 11.2.4.
Couldn't load the XML script into a report. Will look into possibilities to make it work.
Quote from: dougp on 21 Mar 2025 02:45:01 PMI knew about that (, said Doug, sheepishly) because I have used it before.
You know, at my age the hearing is the second thing to go. I can't remember what the first thing was.
Quotesomething like this PowerShell script would work.$fileIn = Join-Path (New-Object -ComObject Shell.Application).NameSpace('shell:Downloads').Self.Path "Book1.csv"
$fileOut = Join-Path (New-Object -ComObject Shell.Application).NameSpace('shell:Downloads').Self.Path "Book2.csv"
Import-Csv -LiteralPath $fileIn | Export-Csv -LiteralPath $fileOut -UseQuotes Always
But if you're going that route, you should also have PowerShell (or your script runtime of choice) run the query to get the data to begin with.
BSP Software Documentation |
MetaManager Documentation and Knowledgebase |
Version Control Documentation and Knowledgebase |
BSP Software | Resources | About Us | ||
MetaManager | BSP Software Training | BSP Software | ||
Integrated Control Suite | YouTube Channel | Micro Strategies Inc | ||
Security Migration | IBM Cognos | |||
Integrated Management Suite | ||||