load measures

[former_member269849]

Hi Folks ,

Please I have a  model that contain Consultant , Module, Time and 3 Measures : Total timesheet ,Tota JO( wich means open Days ) and  not pointed  , we have Not Pointed = Total Timesheet - TO JO , I want to put 1 in each working day and for each month we should have Total timesheet - 20=not pointed, how can i do that ? should i load if ? if yes ( i have a lot of  consultants and lot of modules)

Here is the input form i have

[former_member269849]

he is the input form, but the problem i have timesheet with days wich mean for avery day and they want to have  the diplay with month

[former_member186338]

You have TIME dimension members for each day?

Then I do not understand you "input form" with months?

[former_member269849]

the month is the parent of day i'm displaying parent .

[former_member186338]

Then it's not an input form, it's a report! Please show the input form!

[former_member269849]

Yeah it's a report , i don't have an input form , i'm loading data from a flat file , here is it ,

and i forgot to tell you about task code ,

Task : Task 1 .... and I have a parenth for all theese task , Total Tasks that i'm displaying in the report ( by context)

[former_member186338]

Ok, the original data is clear!

Then explain what you want to calculate (using some detailed sample)!

Vadim

[former_member269849]

I Have signed data wich is total timesheet , and i want to calcutate Not pointed i have  Not Pointed = Total timesheet - Total open days ( 20 days per month) , How can I put one in every day to have 20 for the parent ( every month) I have the value of 20, did you get what i ant to do ?

[former_member186338]

Still not clear, sorry!

Can you show calculations starting from original data?

[former_member269849]

I want to put to load 1 for every line to do calculations ( I ave to load 1 in every Open dayr I have like a property in time dimension (Openday , weekdyay) , and some time I have for the same line 2 values for example a consultant input his timesheet in the morning and in the afternoon  here I have 2 lines , if i do so for ToTal JO I will have to wich not possible .

Sorry I'm trying to do my best

[former_member186338]

Sorry, but absolutely not clear! Please try to explain once again!

Vadim

[former_member269849]

I have to calculate  the not pointed days  , I have workdays(Open days) wich is 8 hours per day but user can input timesheet  4 for for the morning and 4 for the afternoon but also 8 per day, and we have  normaly 20 . how can I load  1 in every Open day to have in each mounth the not pointed days .

[former_member269849]

Because we have not pointdays = Total timesheet - Opendays

[former_member186338]

Sorry, but looks like you have no time to explain the issue clearly:

1. Dimensions

2. Dimension members

3. Dimension member formulas

4. Sample input schedule

Etc...

Vadim

[former_member269849]

No I have Time Vadim,I taught i expalin it clearly.

Dimensions: Module , time ,Consultant, Type_Value

Dimensions members:

MODULE : SD, MM,BPC,BI,PP,QM.

Consultant:Pïerre, Jack...

Time : Days :2015.01.01....

Type_Value: Not pointed days,Total timesheet, TOtal JO wich is Total open days which is 20 days per month