You are not logged in.

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

CNX

Master

  • "CNX" is male
  • "CNX" started this thread

Posts: 72

Date of registration: Nov 12th 2008

Location: Berlin, Germany

  • Send private message

1

Thursday, December 8th 2011, 11:39am

Extract - Filter on an Attribute

Hi,

is it possible to set a filter on a dimension by using an attribute?

For example: Demo-DB. I like to extract some data of cube sales, but only for products which attribute 'color' is 'black'.

In my case I like to filter approx. 50 elements in a dimension with 1.000 elements. I know that there is the possability use a table join transformation to reduce the amount of import data afterwards. But it ist unnesseray to read all data in extract before. This costs to much.

Any suggestions?

CNX
Andreas Malinowski
FORECAST Unternehmensplanungen GmbH, Berlin, Germany
www.forecast.de

Posts: 183

Date of registration: Jan 4th 2008

Location: Freiburg / Germany

  • Send private message

2

Tuesday, December 20th 2011, 12:59pm

Hi,
this is currently not possible. You have to use a TableView to filter

Posts: 364

Date of registration: Dec 2nd 2009

Hobbies: I'll swallow your soul! I'll swallow your soul!I 'll swallow your soul!

  • Send private message

3

Thursday, January 5th 2012, 12:02pm

is this also possible to use a lookup transform in fieldtransform component ?

but it is less performant, isn't it ?
laloune

"A problem worthy of attack proves its worth by fighting back." Piet Hein

  • "a_malinowski" is male
  • "a_malinowski" started this thread

Posts: 72

Date of registration: Nov 12th 2008

Location: Berlin, Germany

  • Send private message

4

Thursday, January 5th 2012, 12:12pm

A lookup only change values or add a column/dimension. If you want to use a value of an attribute for your further operations this is a good way.

But the question was how to reduce the amount of data I have to query in an extract. There is a possability to filter on elements but not on attributes.
Andreas Malinowski
FORECAST Unternehmensplanungen GmbH, Berlin, Germany
www.forecast.de

This post has been edited 1 times, last edit by "a_malinowski" (Jan 5th 2012, 12:58pm)


tomok

Intermediate

Posts: 11

Date of registration: Dec 8th 2011

  • Send private message

5

Thursday, January 5th 2012, 2:25pm

Can't you just use the SUBSET function to do this?

  • "a_malinowski" is male
  • "a_malinowski" started this thread

Posts: 72

Date of registration: Nov 12th 2008

Location: Berlin, Germany

  • Send private message

6

Thursday, January 5th 2012, 2:36pm

That would be nice. But unfortunally subsets aren't supported in ETL. (see this thread)
Andreas Malinowski
FORECAST Unternehmensplanungen GmbH, Berlin, Germany
www.forecast.de

Similar threads

Used tags

Attribute, ETL, Extract, Filter

Rate this thread