You are not logged in.

No context menu available when inserting new elements to a dimension

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.

Columbus

Trainee

  • "Columbus" is male
  • "Columbus" started this thread

Posts: 2

Date of registration: Aug 24th 2009

Location: Germany

  • Send private message

1

Monday, August 24th 2009, 11:31am

No context menu available when inserting new elements to a dimension

Hello,

I try to set-up my first database and cube with Palo Version 3.0 (build 3934) under MS Office Excel 2003 SP3.

Following the steps in the Palo Manual under 5.5 Copying and Inserting elements at page 90 & 91 I realize that I don't get the context menu displayed to use the "Paste elements" function.

I have copied a complete structure from an excel spreadsheet with right mouse click and copy - I open the Modeller - choose the respective dimension, select any element - do right mouse click and nothing happens. No context menu appears, as I would expect it.

Do I do something wrong, or is some setting missing ...?

Any help or hint is highly appreciated.

kind regards

Dirk

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

2

Monday, August 24th 2009, 2:08pm

You do it by the manual - should work like you try it.

What happens when you just paste via CTRL-V ?

The context menu is still valuable when you have to convert numerical elements into string elements ...

Columbus

Trainee

  • "Columbus" is male
  • "Columbus" started this thread

Posts: 2

Date of registration: Aug 24th 2009

Location: Germany

  • Send private message

3

Tuesday, August 25th 2009, 10:43am

Hi

yes, the Palo context menu should work, I agree, but unfortunately it does not.

thanks for the input, Ctrl-V works , but obviously only for a small number of records.

My issue is that I want to fill a dimension with 282 base elements (which is no problem) and a lot of Consolidated elements. The complete structure for this dimension is roughly 1700 rows in Excel long. If I copy and paste it with Crtl-C and Crtl-V it only takes the first two consolidated elements and the rest is ignored.

So for me the question is, how to set-up a complex dimension without entering everything manually ?

Kind regards

Dirk

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

4

Tuesday, August 25th 2009, 10:54am

use the ETL-server

there are many examples in the samples folder ...

introibo

Master

  • "introibo" is male

Posts: 43

Date of registration: Feb 17th 2006

Location: Germany

  • Send private message

5

Wednesday, August 26th 2009, 2:27pm

I had the same problem, but only if the target dimension was already populated. In that case, the context menu only appears after single-left-clicking on one of the existing elements first.

h_decker

Sage

  • "h_decker" is male

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

6

Wednesday, August 26th 2009, 2:58pm

In case of empty dimension window. To set focus on the element window, how about clicking in the left "window" or on the default entry and then right cklick? This helped in my case.
Rate this thread