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

 

News:

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

Main Menu

generate dimensional function

Started by CognosMarson, 05 Feb 2020 10:08:54 AM

Previous topic - Next topic

CognosMarson

Hi,

Im trying to replicate the generate ( [Product line] , topCount ( descendants ( currentMember (
[great_outdoors_company].[Products].[Products] ) , 
[great_outdoors_company].[Products].[Products].[Product name] ) , 2 ,
[Revenue] ) )
function in the great outdoors example, but instead of [Product line] I what to use a case prompt() function that will change depending on what the user chooses. To display this, I've used a crosstab, I have years as the columns and my case prompt() function as outer row and topFunction as inner row, see ugly "table" below.

                          | year
______________|________
            |topCo    |measure
prompt  |_______|________
            |topCo    |measure
______ |_______|________

When I construct the crosstab without using the prompts I get the result I want (for example Returns the top two products by revenue for each product line).
But when I use prompts, the topCount returns a top count of different numbers, sometimes 2, somtimes 8, 10 and so on depending on what I choose to filter on, when it's suposed to return top 2..

Is there anyone that knows why and what I am doing wrong?

/ CM



Francis aka khayman

can you give the prompt expression? as well as the topCo?