data picker application issues

Yugank Bhatnagar

Data Picker

datapicker

syntax

Thomas Ironstone

In BOARD I am trying to use data picker and facing two issues.

Issue 1:

Syntax

@[V024]{GLString=XXXXX;Company=XXXX;Business_Units=001}+@[V024]{GLString=XXXXX;Company=XXXX;Business_Units=002}

The output in the report is not showing the sum, instead show $ value for only the first part of the syntax.

Question is does the Datapicker syntax supports the addition.

Issue 2:

@[V024]{GLString=XXXXX;Company=XXXX;Business_Units=001;ElimFlag=0}

ElimFlag has two values 0 and 1. The flag of 0 and 1 negates the dollar value at account level. When I apply the syntax, I am not getting the dollar value sitting at GL string when the flag is applied.

Any suggestions

Thanks
Yugank Bhatnagar

Find more posts tagged with

Accepted answers

All comments

dirk magerkord

Hi Yugank Bhatnagar

have a look right here

BOARD Data Picker Functionality

I think, this will answer your question.

greetings

dirk

Yugank Bhatnagar

Hi Dirk, thanks but the questions I have are not answered in the Page you referenced to

Thanks

Yugank

Alexander Kappes

Dear Yugank Bhatnagar,

dirk magerkord was right linking the document.

Because in this is written, that mathematical calculations are not supported in the datapicker.

Means your issue No. 1 can´t even work. To get it work e.g. you have to put the two datapickers into separate cells of your rule and the Addition must been done in a third one.

Concerning your second issue. Did you have checked what happened, when you perform the selection on a separate (temp) Screen and just insert the cube into a dataview. Do you receive the wished results? For that case it will work in the same way in the datapicker. I think there isn´t really a Problem with the datapicker.

regards

Alexander Kappes

Paul Wyatt

Hi Yugank,

Are you still having issues with this matter? Here is an image of a solution I currently use. I've used a rule using datapicker and placed a template on the entity (figures pixellated) The [Total Floor Area (m²)] and [Total Covers] values were calculated within the rule:

Image 1: Entity with template and rule applied using datapicker. Red boxes show rule calculated results.

Method - in brief

I needed to SUM the values of cubes V100, V099 and V101 and I also needed to SUM the values of Cubes V096 and V097. To do this, I included two lines within the entity - L06 for the first SUM and L10 for the second SUM.

Below are images and notes of the entity and rule I used to achieve the outcome I needed.

Image 2: Entity [REPORT PS Property Summary]

Image 3: Rule [Property Search - Property Summary]

L06 and L10 can be seen to be calculating the lines (members) of the entity and not the source cubes. It may be that your initial design does not allow for lines to be used in such a way. As this is one of the limitations/features of the datapicker, outlined in the document reference by dirk magerkord, you would need to add additional lines and carefully design your entity.

If you're still having issues, please could you post an image of your entity and rule?

Hope this Helps.

Regards,

Paul Wyatt

Yugank Bhatnagar

Thanks Paul for the detailed explanation. But unfortunately my model would need too many lines to be added which would be hard to maintain. But surely your solution may help me in future.

Can you suggest a solution for Issue 2:

Issue 2:

@[V024]{GLString=XXXXX;Company=XXXX;Business_Units=001;ElimFlag=0}

Thanks

Yugank