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

Slicer problem Cognos 10.2

Started by mindNET, 02 Jun 2017 06:02:00 AM

Previous topic - Next topic

mindNET

Hello!

I don't have a lot of experience with dimensional models so I've ran into this issue ( which in relational sorts out pretty easy )

Model: Dimensional
Task: Report should display only those products which price is > 4.50

So the problem is that there is a lot of prices ranging from 0 to 20000 price itself is a member not a measure. This seems a pretty straight forward task but I'm stuck with this. Would really appreciate any help. Thank you!

MFGF

Quote from: mindNET on 02 Jun 2017 06:02:00 AM
Hello!

I don't have a lot of experience with dimensional models so I've ran into this issue ( which in relational sorts out pretty easy )

Model: Dimensional
Task: Report should display only those products which price is > 4.50

So the problem is that there is a lot of prices ranging from 0 to 20000 price itself is a member not a measure. This seems a pretty straight forward task but I'm stuck with this. Would really appreciate any help. Thank you!

Hi,

Can you explain how price is a member not a measure? It sounds like it should be a measure to me? Or are you saying it's an attribute of a Product member? Can you elaborate?

I'd be looking at using the filter function for this in a query calculation

eg filter( [your Product level], [your Price attribute or measure] > 4.50)

Does that give you the results you need?

MF.
Meep!

mindNET

Using filter was my first try but it ends up with an error

The argument at position 1 of the function '>' is invalid in data item 'Data Item1' of query 'Query1', expected one of the following types: 'value'.

New_Guy

Hi,
Like MFGF said, if you want to use filter function you have to have a measure value. Does the cube has any measure and which cube are you using?

Good luck
New guy

mindNET

#4
Quote from: New_Guy on 02 Jun 2017 07:14:46 AM
Hi,
Like MFGF said, if you want to use filter function you have to have a measure value. Does the cube has any measure and which cube are you using?

Good luck
New guy

As I've stated in my post above that Price is not a measure it's a separate hierarchy hence it does not fit the requirements for using filter function. The cube does have measures but they have nothing to do with the task that I'm trying to accomplish. If I understand your question correctly it's a microsoft cube.

So you might think of using except and just put all the price values in there, but there are always new prices being added so the slicer would not cover everything then. I though of using head or tail but again member index will shift whenever new price is added to the hierarchy.

MFGF

Quote from: mindNET on 02 Jun 2017 07:30:04 AM
As I've stated in my post above that Price is not a measure it's a separate hierarchy hence it does not fit the requirements for using filter function. The cube does have measures but they have nothing to do with the task that I'm trying to accomplish. If I understand your question correctly it's a microsoft cube.

So you might think of using except and just put all the price values in there, but there are always new prices being added so the slicer would not cover everything then. I though of using head or tail but again member index will shift whenever new price is added to the hierarchy.

Hi,

I'm struggling to see the logic here if Price is a set of members in a different hierarchy. How does a Price member relate to a Product member? Do they share a common measure you could utilise? Can you explain more about the structure of your cube?

MF.
Meep!