Time format update in Property values

[BalaValluru]

Dear Experts,

Below logic is not restricting to time updated in Start and End date properties. And calculating for all the periods

Just want to script make it to work for one PO.. Any change is required for time format update in property values.

Thanks

Kishore V

[former_member186338 · Accepted solution]

Sorry, but your script is restricting nothing!

You really have to read some basic documents about script logic, not only copy-pasting code...

*SELECT(%START%,START_DATE,PO,ID=%PO_SET%)
*SELECT(%END%,END_DATE,PO,ID=%PO_SET%)
*SELECT(%STARTTID%,TIMEID,TIME,ID=%START%)
*SELECT(%ENDTID%,TIMEID,TIME,ID=%END%)
*SELECT(%PERIODS%,ID,TIME,TIMEID>=%STARTTID% AND TIMEID<=%ENDTID%)

*XDIM_MEMBERSET TIME=%PERIODS% //Scoping periods between start and end
*XDIM_MEMBERSET ACCOUNT=Total_Area //Scope ACCOUNT to SINGLE member!

*WHEN ACCOUNT 
*IS * //already scoped
*REC(EXPRESSION=%VALUE%*[ACCOUNT].[Rate_Sqft],ACCOUNT=Base_Rent,AUDITTRAIL=Input_BR)
*ENDWHEN

Absolutely simple script!

[BalaValluru · Accepted solution]

vadim.kalinin

Super working perfectly .Your the Master of BPC script 🙂

[former_member186338 · Accepted solution]

valluru

The script is absolutely simple...

[BalaValluru · Accepted solution]

vadim.kalinin

Ex: selecting *XDIM_MEMBERSET Time =2014.04,2014.12

script is working only for two periods 2015 APR and 2015 DEC only

But I want to make script to work Between periods also. (FROM 2015.APR to 2015 DEC). Appreciate you help

*XDIM_MEMBERSET TIME=%PERIODS% //Scoping periods between start and end

[former_member186338 · Accepted solution]

"Ex: selecting *XDIM_MEMBERSET Time =2014.04,2014.12 ..." - is it a joke???

SELECTS:

*SELECT(%START%,START_DATE,PO,ID=%PO_SET%)
*SELECT(%END%,END_DATE,PO,ID=%PO_SET%)
*SELECT(%STARTTID%,TIMEID,TIME,ID=%START%)
*SELECT(%ENDTID%,TIMEID,TIME,ID=%END%)
*SELECT(%PERIODS%,ID,TIME,TIMEID>=%STARTTID% AND TIMEID<=%ENDTID%)

in my code are performing calculation of periods between dates (including)!

[BalaValluru]

vadim.kalinin

Sorry its typo *Time 2014.04,2014.12 ( Correct : 2015.04,2015.12)

[former_member186338]

Sorry, but both statements are meaningless!

I have already told you - please read some basic documentation about script logic! Search GOOGLE