Search Results

Search results 1-20 of 22.

  • User Avatar

    RE: creating consolidation

    lesuere - - Palo ETL

    Post

    hi blabj and Nico, it works now! that's not the hierarchie that i wanted or how i'd visualized. but its ok!! a million thanks to you both. have a good weekend! bye for now! kind regards, lesuere

  • User Avatar

    RE: creating consolidation

    lesuere - - Palo ETL

    Post

    hi Nico, first, thanks for answering these questions! and how do i do this? please, i need more information. what had I best do? can you give an example? regards, lesuere

  • User Avatar

    RE: creating consolidation

    lesuere - - Palo ETL

    Post

    oops! I meant , i've to define (map) 265 elements to define 4 "Quarter"? regards

  • User Avatar

    RE: creating consolidation

    lesuere - - Palo ETL

    Post

    hi blabj, thanks once again for answering if i understand you correctly, i've to map all my elements? the data values that will be used by flat file for the dimension are: 01.02.2002 02.02.2002 03.02.2002 04.02.2002 05.02.2002 06.02.2002 07.02.2002 08.02.2002 . . . 01.03.2002 02.03.2002 . . . 01.04.2002 . . . 31.12.2009 That means, i've to define (map) 265 elements to define the "Quarter"? like this: 01.01.2001=Jan; 02.01.2001=Jan; 03.01.2001=Jan;... 01.02.2002=Feb; 02.02.2002=Feb; 03.02.2002=Fe…

  • User Avatar

    I found my mistake. I forget to set default value 0. at trying to modify the existing extract by "Alias Map". lesuere

  • User Avatar

    RE: creating consolidation

    lesuere - - Palo ETL

    Post

    for a better understanding of my problem this is the struktur(hierachy) of the dimension now. C AllBuchungsdatum 2000.1.1 1 2000.1.2 1 2000.1.3 1 2000.2.5 1 2000.3.9 1 2000.4.10 1 2001.1.3 1 2001.2.4 1 2001.3.9 1 2001.4.10 1 2002.4.12 1 2003.1.1 1 2004.2.5 1 2005.4.10 1 2006.4.12 1 2007.2.5 1 2007.2.6 1 2008.3.9 1 2008.4.10 1 2009.4.12 1 2010.1.1 1 . . . but what i want a hierachy like this: C AllBuchungsdatum c 2000 c Quartal 1 2000.1.1 1 2000.1.2 1 2000.1.3 1 C Quartal 2 2000.2.5 1 C Quartal 3…

  • User Avatar

    RE: creating consolidation

    lesuere - - Palo ETL

    Post

    hello blabj, thanks for answering. thats right, but the TreeFH can only used for one consolidation hierachy in one dimension, or? because the TreeFH offers only one source and one target with input for one dimension. for example: if i got elements like 2002.1.1 - 2009.12.31 (for a better view it needs more consolidation) and i've got only one dimension "Buchungsdatum", and would enjoy to create 9 hierachies for the years and for one of this hierachy secondary another 12 hierachies for the months…

  • User Avatar

    creating consolidation

    lesuere - - Palo ETL

    Post

    hi guys. at the moment i'm trying to import data into a palo database by flate file. and i'm trying to create some consolidation more in existing consolidation. to create a consolidation for a dimension is not a problem for me, but to create more of a consolidation among other consolidations. how is this realizable? the etl-server-documentation gives not enough information about creating more consolidation for one dimension. can somebody help me? thanking you in anticipation kind regards, lesuer…

  • User Avatar

    Hello you palo-guys. Here I’m with another problem I'm useing an csv-file for import data to palo data base. The csv file got a column which is empty. And therefore i can’t make a report with “Ansicht einfügen” in Excel. It is also impossible to get an aggregate value. The column is define by tabletransform for a Measure-dimension. For a better understanding here the warn message (see below): 2010-02-11 12:36:56,594 INFO : Starting execution of job JOB_CUBE 2010-02-11 12:36:56,594 INFO : Paramet…

  • User Avatar

    Hello axi, thank you for your idea. but i don't kown how to use the programming languages correctly. So i will work by the old ;-)... However, i'm looking for new ideas. so let me ever know. because it's interesting. thanks for the information. kind regards. lesuere

  • User Avatar

    That was very helpful, Holger. Thank. Now, I have to extract all the files from the sap-system again. Kind regards. lesuere

  • User Avatar

    Quote: “Originally posted by lesuere Hi. Thanks for your fast answering. The original value does look like in the csv file is : -1.636,13. lesuere”

  • User Avatar

    Hi. Thanks for your fast answering. The original value does look like in the csv file : -1.636,13. lesuere

  • User Avatar

    Hi you palo-guys. I'm useing an csv-file for import data to palo data base. On starting the job i get a error message: "WARN : Failed to insert value -1.636.13 of column Kum. Saldo into table MeasureTableTransform: multiple points" The reason for this problem is how to define or rather modify an transform (TableTransform - Measures). At the classification of testing “TableTransform” the "Information Dialog" shows an "OK". But i get a warning when i try to test "Preview data" so I get the same er…

  • User Avatar

    Hello Holger, Thank you for your fast answer! I will uninstall and reinstall Palo by the end of January...because i've got not so much time now. Bye for now! Best regards, Leyla

  • User Avatar

    deleted database "Demo" accidentally

    lesuere - - General

    Post

    hello. i deleted database "Demo" accidentally by using the "Import Assistent". how can i undo deleted database "Demo"? can sombody help me, please? thanking you in anticipation, leyla p.s. i wish you all a very beautiful and relaxed christmas time

  • User Avatar

    RE: import attributes

    lesuere - - Palo for Excel

    Post

    hello again. i’ve got another problem now… i took notice the import assistant didn’t import all the data. it’s importing only 5 of 20 – 30 attributes. I get error but the error message is empty. Does somebody know the problem? Thanks

  • User Avatar

    RE: import attributes

    lesuere - - Palo for Excel

    Post

    Hello Kratzer. Thanks for answering my question! It was really helpful to me! Best regards

  • User Avatar

    import attributes

    lesuere - - Palo for Excel

    Post

    hello. i'm trying to import a lot of attributes from csv into the palo olap server. is this possible with the "Import-Assistent" or "SetData funktion"? or i really have to creat all the attributes with the "modeller"? thanking you in anticipation

  • User Avatar

    CSV to Palo; error message

    lesuere - - Palo ETL

    Post

    @Phil Ro First, thanks for your answer. No it doesn't, the dimension named vorgang, but the value is empty. Can you tell me how the change the settings in the ETL Server for a successfull import?