BI tools- Zap Help

hi everyone,

help!!! i am trying to find zap tutorials, forum but in vain… [:’(]

anyone knows where to get help? [:(]

firstly, the documentation(user guide) i have does not include tutorials but describing technical functionalities only [8o|]

i am trying to use navision report 113(Customer/Item Sales) and convert it to zap analysis report…

the dataitem of the report as follows:

Lv1: Customer,

Lv2: Value Entry (linked by Source No.=FIELD(No.), Posting Date=FIELD(Date Filter),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter)

Lv2: Integer

Questions is how to link customer and value entry by source no., posting date??

Hi,

There is now publicly view-able support forum. You will need to register to post:
https://zendesk.zaptechnology.com

To answer your questions:

  • Value Entry already relates to Customer using the [Source No. Customer] column.

  • Value Entry also relates to Date using the Posting Date column.

  • Value Entry will relate to any financial dimensions you have selected to include.

You can achieve a report similar to 113 by simply dragging measures from the Value Entry measure group to rows, then Customers and Items to rows.

The reason why you don’t need Posting date and Global dimension codes as part of the Value Entry → Customer relationship is because in a cube (unlike Flow Fields in nav) measures are filtered automatically according to the context of the calculation. For example in this report the dates in slicer and the Items, Customers on rows all filter the value you see in the columns.

hi

https://zendesk.zaptechnology.com

[Y]