Hello experts,
I am looking for a way to calculate the number of days from one date to another and add the days of each month.
For example
from 10/07 (start date) to 31/07 = 21 days
from 01/08 to 31/08 = 31 days + 21 = 52
and so on until an...
Hi experts,
I am trying to make a chart that shows only the most recent certifications of the workers. If a worker has more than one certification, it should only add up the most recent one.
The groups I have are:
- Updated (<5 years)
- Be...
HI,
I have to replicate reports made in BO in SAC. Each report has a query in BW but they are all within the same SDO.
can you help me with these questions please.
What is the best way to import the information into SAC?
Can I create a model ...
Hi experts,
I am trying to make a data action that calculates the average cost per employee. The formula I have to use is:
total cost / headcount
In order to do this it is necessary to group by the different combinations of employee type and ...
Hi,
Im triying to get a total value from table using OnSelect properties. If i use
Table_1.getDataSource().getResultSet();
i get all table data but i need only the selected. On another hand, when i use
Table_1.getSelections();
i get the ...
thanks for your support nikhil_1486I have been trying but I am not able to reach the expected result. this is the previous calculated measure and its result filtered by only one employee (to check the result)and have sense because this employee have...
thanks for your answer marc.kuipers, but I don't think that's what I'm trying to do. I just posted another example in case that could clarify my question.Thank you very much for your time.
nikhil_1486 Thanks. This partially solves my problem. I need it to only add up to 1 per person, even if I have more than one updated certification.example: This employee has more than one certification up to date (<5 years). I need this employee in...
Hi william.yu Yes, you are right. Filtering the table I managed to see the data after executing the data action.But now I don't know why after executing it creates new lines of data that didn't exist before instead of overwriting the existing ones.t...
hello william.yu, I appreciate your response.I have tried to do what you recommend
MEMBERSET [d/type_employee] = "TE_01"
DATA([d/Measures]="average_cost") = RESULTLOOKUP([d/Measures]="sum_upa", [d/employee_id]="#",[d/office]="#",[d/personal_group]...