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

How to choose a appropriate set in Calculation

Started by Palczan07, 23 Apr 2021 07:18:39 AM

Previous topic - Next topic

Palczan07

Hello Everyone,

today I have a problem with Cognos calculations when I'm creating a dashboard. My data module comes from IBM Planning Ananlytics cube. I want to count a appropiate measure. I'm trying to do this with command. My Command is


count([Cube_1].[Dim_1].[Meas_1] within set filter(tuple([Cube_1].[Dim_2].[Dim_2]),[Cube_1].[Dim_3].[Dim_3],tuple([Cube_1].[Dim_4].[Dim_4]),tuple([Cube_1].[Dim_5].[Dim_5]),tuple([Cube_1].[Dim_6].[Dim_6]), [Cube_1].[Dim_1].[Meas_1]) = 'string')
)


but this code doesn't working. I don't know what can I do  :(.

Can You have a similar problem? If somebody have information how indicate appropriate Dimension and Element from Cubes, please help me . :)

MFGF

Quote from: Palczan07 on 23 Apr 2021 07:18:39 AM
Hello Everyone,

today I have a problem with Cognos calculations when I'm creating a dashboard. My data module comes from IBM Planning Ananlytics cube. I want to count a appropiate measure. I'm trying to do this with command. My Command is


count([Cube_1].[Dim_1].[Meas_1] within set filter(tuple([Cube_1].[Dim_2].[Dim_2]),[Cube_1].[Dim_3].[Dim_3],tuple([Cube_1].[Dim_4].[Dim_4]),tuple([Cube_1].[Dim_5].[Dim_5]),tuple([Cube_1].[Dim_6].[Dim_6]), [Cube_1].[Dim_1].[Meas_1]) = 'string')
)


but this code doesn't working. I don't know what can I do  :(.

Can You have a similar problem? If somebody have information how indicate appropriate Dimension and Element from Cubes, please help me . :)

Hi,

The expression you posted doesn't look like legal syntax. What are you trying to achieve with the tuple() functions here? Tuples return either a slice or the value at an intersection in your cube. What they don't return is members, but your expression is trying to count a measure with in a set of members. You also have a filter() function - what are you trying to filter? Can you explain what you are trying to do here?

Cheers!

MF.
Meep!

Palczan07

Thank for your answer.

I have a problem with a set. I want to count elements which element is equal with string. This string is between below intersection.

Cube - Demand Profile
Products - subset (all elements)
Time - element (No time)
Market - subset (all elements)
Version - subset(Actual)
Meas dim - Demand profile

I want to count product for every market with demand profile = lumpy.