Search Results

Search results 1-20 of 24.

  • User Avatar

    Hello Holger, thanks for your answer - I have assume this progress with sorrow. Regards, Jürgen

  • User Avatar

    Hello, could it be, that with the Cubeware free-limited no access to Jedox PALO cubes are possible "missing cwiopalou.dll"? IMPPalo is not installed, but both lib..ng.dll's are in the subs \Common\Cubeware and \Jedox Palo Knows anybody a solution? Thanks, Jürgen

  • User Avatar

    Empty cells - predefined values

    JuergenK - - Palo ETL

    Post

    Solved: at define REALTIONAL table the EXTRACT filling out the DEFAULT cell with "N.A." - no rules needed.

  • User Avatar

    Empty cells - predefined values

    JuergenK - - Palo ETL

    Post

    Hello, I have a TreeFH with 4 levels, but at 2nd level I have sometimes empty cells, which I want to fill up with value "n.a." How can I do that? I suppose about defining a rule - but what would be the syntax of such a rule? Thanks for support, Juergen

  • User Avatar

    Hello Robert, Cubeware Importer is the first choice in ETL processes. But for learning basics of ETL, especially cube methodes, the Palo ETL is perfect. IMP Palo is time limited, therefor I don't want to use it. Regards, Juergen

  • User Avatar

    Hello, I've problems with warning during my job generates the MASTERDATA. Before I have joined two tables: one flat table, the other one result of TreePC (aggregation of same content, format string). 'WARN : Source TABLEJOIN of load LOAD-DIMENSION has to be a tree for the loading of consolidations. Dimension will be flat.' in my protocol. Does anybody can help me? Thanks! Juergen

  • User Avatar

    Great! I don't or find this samples before... all things with examples I want to know about it Thank you very much! Regards, Juergen

  • User Avatar

    I know only "Biker" what is very helpful. Other examples I couldn't found in setup. Do you know further examples? Regards, Juergen

  • User Avatar

    Hello Michel, thanks a lot! This was the solution... Regards, Juergen

  • User Avatar

    Hello Robert, yes I have reading the ETL manual v3.1 pdf. But the manual shows only the basics... A workflow with possibilities and examples would be perfect. Of course, I know biker too. Thanks, Juergen

  • User Avatar

    Hello Robert, yes, I can see all the dimensions at Excel addon but no one at IMP Palo. Thanks, Juergen

  • User Avatar

    Hello Holger, thank you, that was the problem. I will experimente with the "Three-" s to find the exact processes. Thanks, Juergen

  • User Avatar

    JOB don't creat CUBE

    JuergenK - - Palo ETL

    Post

    Hello, until now I couldn't create my cubes effective for working at Excel too. I need the ETL process for data imports, but I haven't found the right way to call them (with dimensions) at Excel. Have anybody an workaround or workflow solution? Thanks, Juergen

  • User Avatar

    Hi, I have created database and cubes at PALO ETL Server. I start IMP:Palo and find the created database, but not dimensions, cubes, etc. Has anybody an idea? Thanks, Juergen

  • User Avatar

    Hello, I get always as a JOB result the warning: "WARN : Source TRANS KundeUmsatz of load LOAD KundenUmsatz has to be a tree for the loading of consolidations. Dimension will be flat" Maybe anybody can tell me what it means? Thanks, Juergen

  • User Avatar

    JOB don't creat CUBE

    JuergenK - - Palo ETL

    Post

    Hello, thanks for answers. Indeed I have forgotten the DIMENSIONS in LOADS. I will have a look at the order of the dimensions in the load. Thanks, regards Juergen

  • User Avatar

    Hello Robert, I think no. It seems that SQL syntax will not changed after saving first syntax. Sorry, but I'm not a DB specialist... I haven't the background to analyze the problem in details - I'm happy, that no problems go on an longer And thank you for your help! Regards to Austria, Juergen

  • User Avatar

    JOB don't creat CUBE

    JuergenK - - Palo ETL

    Post

    Hi everybody! I have created a TABLE JOIN and than a LOAD CUBE. I have tested both and I got no warnings. After this steps I create a JOB, with these LOAD CUBE but I got following warning: "ERROR : Cannot import Data into Cube Kunden_Umsatz: Failed to initialize cube Kunden_Umsatz: Dimension NUMMER does not exists." The Dimension NUMMER is the first column in the table. I have tried CREATE, ADD, UPDATE CUBE but no success. Can anybody help me please? Thanks, Juergen

  • User Avatar

    I 've found the problem: When I try chance SQL syntax after I have saved it, I got this problems with the new or changed syntax. I don't know why...

  • User Avatar

    Hello, thanks for answer. I call (SELECT table1, table2, etc.) only 86 columns, not 120 ones. Another table - from same Access DB - with 220 columns I can handle without any problems. Does anybody has an idea? Thanks