Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Shipped
Workspace Jedox Platform
Categories Other
Created by Guest
Created on Jul 2, 2019

Palo.SetdataBulk - dimension parameters as single columns rather than block

Frist of all the new setdatabulk function works great. It increases the performance of Excel based upload by far. However the dimension parameters of the formula need to be defined as block. This is fine but in terms of designing compact and structured inputsheets it results in huge excel areas of upload blocks even though just one dimension parameter is changing. I would like to have the ability of defining every dimension parameter as single parameter to keep the sheets easy to maintain. Block: palo.setdatabulk(db;cube;A1:C20;D1:D20) Columns: palo.setdatabulk(db;cube;A1:A20;B1:B20;C1:C20;D1:D20)
  • ADMIN RESPONSE
    Jul 2, 2019
    Such functionality is already present in 5.1 (PALO.SETDATAA).
  • Guest
    Reply
    |
    Jul 2, 2019
    Great idea. That would be very important to use this function more often.
  • Guest
    Reply
    |
    Jul 2, 2019
    Sounds great. Where is a documentation about PALO.SETDATAA?? I didn't find in the knowledge base or in the Excel Client (5.1 SR3).