cognos

Hello, I have Power BI Pro installed as part of our E5 license and I am trying to evaluate it in thoughts of using it instead of our current IBM Cognos setup (that we pay extra for) fo rquerying our SQL server tables... However, the one concern I have that I do not think Power BI can do - but...

I am very new in SQL and the software IBM Cognos and I was tasked as an intern to create a report with a header ((months) 1, 2, 3) and under this header an actual value and a target value. What I am looking to do is to filter out the blanks in the cells actual and target values under a certain...

I'm still fairly a beginner with vba in general, but have managed to do a few things. I'm interested in a way to use vba to append data to an access table from excel. I'll have to do this for multiple different reports. I have multiple reports that I run via IBM's Cognos Impromptu to which...

Hi I have this problem: I am extracting data from Cognos Controller. Cognos Controller stores data in accumulated numbers over the year. To find the period value (as opposed to the accumulated value) for a period I have first made a calculated column in my Fact-table that makes a transactions...

Hi I am very new to VBA, and I am using a working model to learn as I go. So appologies for my lack of correct terminology etc. Basically I am trying to download sales figures from our IBM COGNOS sales database using VBA code. I have no issue opening the page with the data I want...