You are not logged in.

Inserting subset

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.

ethssn

Master

  • "ethssn" is male
  • "ethssn" started this thread

Posts: 54

Date of registration: Feb 16th 2012

Location: Hamburg

Occupation: BI-Consultant

  • Send private message

1

Wednesday, June 13th 2012, 6:23pm

Inserting subset

I have one question about subsets: How to insert it? Sounds a little bit stupid, but I did not find out by doing or searching here or RTM, how to get a plain vertical list of dimension base elements, which spans as long downwards as needed to display all base elements or dynamically just those allowed to view by the user. The subset itself is designed as a global one.
Do I need to highlight the complete space on the spreadsheet before inserting? How could I know the largest span size of it ever in advance? Is there a function/shortcut to indicate "as needed" ?
Or just inserting the subset in the topmost cell? But if I do this, I dont receive a long list in user mode, but only one value...
Could I get somewhere a more detailled description how to use dynaranges in an advance manner? The manual just gives a very short example and states only, that its dynamic, but nowhere in detail something about tricks and special cases...

Best regards,
Stefan

kratzer

Master

  • "kratzer" is male

Posts: 87

Date of registration: Feb 23rd 2006

Location: Karlsruhe

Occupation: IT

  • Send private message

2

Wednesday, June 13th 2012, 7:41pm

Once you have defined a dynarange (e.g. vertical) you may of course insert an existing subset or create one on the fly while inserting. Your view will dynamically adjust, that is the number of rows will match the number of your subset elements. No need to mark the whole expected range. Try again.

ethssn

Master

  • "ethssn" is male
  • "ethssn" started this thread

Posts: 54

Date of registration: Feb 16th 2012

Location: Hamburg

Occupation: BI-Consultant

  • Send private message

3

Thursday, June 14th 2012, 10:47am

OK, thanks a lot. That's what I expected after reading the web manual, so I might have done something simply wrong...

Similar threads

Used tags

web subset insert length size

Rate this thread