If you are unable to create a new account, please email support@bspsoftware.com



MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dimensional Functions in Framework Manager

Started by andigrill, 23 Sep 2022 07:01:05 AM

Previous topic - Next topic



Until recently we used Cognos Transformer for creating Cubes. Because it's still 32-Bit and doesn't work too well with huge data we are starting modelling cubes in Framework Manager.
Datasource are Oracle Tables.

However, there are still some features of Transformer we are not sure how to implement in FM:
In time dimensons we want to have the same 'Current Month','Last month' Month before last month' and so on like transformer automatically creates.
Of course it's possible to have a table with the needed Dates and filter them for alternating hierarchies.
But how can you use the cognos Dimensional functions?
I tried
tail ([Dimensional Layer].[Date Dimensional].[Date].[Year]) and testing it delivers the correct value.
When I publish the package and open the Cube in Analysis Studio and expand the Hierarchy I get the message:
GEN-ERR-0016 : The 'tail' Function is Not Supported in the Context in Which It is Used

Where is the error?


Did you know that 'huge data' doesn't work in Framework either and that's exactly IBM introduced Dynamic Cubes.


We tried DynCubes too and the Performance is pretty similar.


What's the definition of 'huge data' ? How many rows from each transaction/fact table?

It might be possible that the cubes are not built properly or the database is not efficient. I have had cubes with 90 million+ rows and worked with acceptable performance.