Databases Reference
In-Depth Information
2.
Decide that you only want to calculate
Gross
Stock
for the
Current
and
Forecast
time periods.
3.
Recode your
FIX
and
ENDFIX
command statements to look like this:
FIX(@UDA("Calendar Periods","Current") OR
@UDA("Calendar Periods","Forecast"))
"Gross Stock" = "Production" - "Sales";
ENDFIX
Aren't
FIX
and
ENDFIX
commands the greatest?
Always remember with
FIX
and
ENDFIX,
you
want to
Fix
on
Sparse
dimensions and
IF
on
Dense
dimensions.
EXCLUDE/ENDEXCLUDE
Well there you have it! With the release of Essbase version 9.x we now have
EXCLUDE
and
ENDEXCLUDE
commands to compliment the
FIX
and
ENDFIX
commands.
Now, without confusing you, we can tell you to consider the
FIX
and
ENDFIX
commands as an include statement that tells Essbase what data to keep for calculating.
And, if including data proves difficult (and there are times it will), then you now have
the
EXCLUDE
and
ENDEXCLUDE
commands to tell Essbase what data to leave out when
selecting data for calculating. See examples in the next section.