Forecast, Sort Values and Calculations

Discussion forum for PivotCubeX component. Common usage questions. Bug and problem reports

Moderator: Alex Zencovich

Forecast, Sort Values and Calculations

Postby TACTICA » Fri Dec 26, 2008 10:40 pm

Hi,

I can figure out how to work with the forecast function?

Any example using PivotCube ActiveX? (Note: I´m talking to end user level).

I have several month names in spanish but i can not sort by the default option of sorting....I think is the same problem in any language.

How can I sort the month by name? I could not figure out how to sort values manually? Any Example?

Finally...

I want to use the calculated field.....I need some examples......Using Column, Row...

Thanks a lot.....
TACTICA
User
 
Posts: 13
Joined: Thu May 22, 2008 3:13 pm

Re: Forecast, Sort Values and Calculations

Postby AlexZencovich » Sat Dec 27, 2008 5:19 pm

TACTICA wrote:Hi,

I can figure out how to work with the forecast function?

Any example using PivotCube ActiveX? (Note: I´m talking to end user level).

I have several month names in spanish but i can not sort by the default option of sorting....I think is the same problem in any language.

How can I sort the month by name? I could not figure out how to sort values manually? Any Example?

Finally...

I want to use the calculated field.....I need some examples......Using Column, Row...

Thanks a lot.....


1. Please take a latest package, it has a fix for work with forecating functions. Probably your troubles just related to that.
2. Please, set sort by Name or sort by key. usually in case of month oyu have to sort months' by key as their key values is 1,2,3..12 and names (Jan,Feb,March...Dec) does not corrspond in alpha order
3. I suppose you to take PivotCube VCL package and take user guides from that package as it may give you much better understaning of PivotCube VCL internals.
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am

Re: Forecast, Sort Values and Calculations

Postby TACTICA » Sat Dec 27, 2008 9:15 pm

Where can I download the lastest version?

3. I suppose you to take PivotCube VCL package and take user guides from that package as it may give you much better understaning of PivotCube VCL internals.

I mean, information at the end user level. I´ve installed the trial package but there´s not enought information about it.

Thanks
TACTICA
User
 
Posts: 13
Joined: Thu May 22, 2008 3:13 pm

Re: Forecast, Sort Values and Calculations

Postby AlexZencovich » Sun Dec 28, 2008 10:03 am

TACTICA wrote:Where can I download the lastest version?

3. I suppose you to take PivotCube VCL package and take user guides from that package as it may give you much better understaning of PivotCube VCL internals.

I mean, information at the end user level. I´ve installed the trial package but there´s not enought information about it.

Thanks


Look at "visual guide" at trial package.

The forecating methods usage have to work very simple - just by set <Next> or <Prev> checkboxes at dimension editor. it have to be 0 only in case if number of base values for forecasting less than 3. Forecasting calulated as next point on curve created by given data set.
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am

Re: Forecast, Sort Values and Calculations

Postby TACTICA » Sun Dec 28, 2008 2:49 pm

Hi,

I´ve found this from you....

Simple Moving Averages

The best-known forecasting method is the moving averages
method. It simply takes a certain number of past periods and
adds them together, then divides the result by the number of
periods. Simple Moving Averages (MA) is an effective and
efficient method provided the time series is stationary in
both mean and variance. The following formula is used in
finding the moving average of order n, MA(n) for a period
t+1:



MAt+1 = [Dt + Dt-1 + ... +Dt-n+1] / n



where n is the number of observations used in the calculation


Weighted Moving Averages

Very powerful and economical. It is widely used where
repeated forecasts requires methods like sum-of-the-digits
and trend adjustment methods. An example of a Weighted Moving
Averages calculation is as follows:

Weighted MA(3) = w1.Dt + w2.Dt-1 + w3.Dt-2

where the weights are any positive numbers such that: w1 + w2
\+ w3 =1. A typical weights for this example is, w1 = 3/(1 +
2 + 3) = 3/6, w2 = 2/6, and w3 = 1/6.

Exponential Smoothing Techniques

One of the most successful forecasting methods is the
exponential smoothing (ES) method. While the simple MA method
is a special case of the ES, the ES is more conservative in
its data usage. It also offers the following advantages:

§ can be modified to be used effectively for time series with
seasonal patterns

§ easy to adjust for past errors

§ easy to prepare follow-on forecasts, which is ideal for
situations where many forecasts must be prepared and several
different forms are used depending on the presence of trend
\or cyclical variations

In short, an ES is an averaging technique that uses unequal
weights, where the weights applied to past observations
decline in an exponential manner, as follows:



Ft+1 = a Dt + (1 - a) Ft

where:

Dt is the actual value

Ft is the forecasted value

a is the weighing factor, which ranges from 0 to 1

t is the current time period.

Notice that, the smoothed value becomes the forecast for
period t + 1.

A small a provides a lot of smoothing while a large a
provides a fast response to the recent changes in the time
series and a smaller amount of smoothing. Notice that the
exponential smoothing and simple moving average techniques
will generate forecasts having the same average age of
information if moving average of order n is the integer part
\of (2-a)/a.

An exponential smoothing over an already smoothed time series
is called <B>double-exponential smoothing</B>. In some cases,
it might be necessary to extend it to <B>triple-exponential
smoothing</B>. While simple exponential smoothing requires
stationary condition, the double-exponential smoothing can
capture linear trends and triple-exponential smoothing can
handle almost all other business time series.



And number of methods (for forecast) can be easily expanded if it required.

Can you?
TACTICA
User
 
Posts: 13
Joined: Thu May 22, 2008 3:13 pm

Re: Forecast, Sort Values and Calculations

Postby TACTICA » Sun Dec 28, 2008 3:13 pm

I could not find information abou the calculated fields....

Can you provide me some examples?

Thanks.
TACTICA
User
 
Posts: 13
Joined: Thu May 22, 2008 3:13 pm

Re: Forecast, Sort Values and Calculations

Postby AlexZencovich » Sun Dec 28, 2008 6:53 pm

TACTICA wrote:I could not find information abou the calculated fields....

Can you provide me some examples?

Thanks.


Calculated fields? May be you mean calc. measures? Look at calc. measures foumula language.
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am

Re: Forecast, Sort Values and Calculations

Postby TACTICA » Sun Dec 28, 2008 9:34 pm

Sorry, but can you point me exaclty where can i find information on how to do it?

I´m not the programmer, I´m the guy who will create the documentantion for the end user...

I need a little more help to undestand better this great product....

Thanks a lot...
TACTICA
User
 
Posts: 13
Joined: Thu May 22, 2008 3:13 pm

Re: Forecast, Sort Values and Calculations

Postby AlexZencovich » Mon Dec 29, 2008 6:38 pm

TACTICA wrote:Sorry, but can you point me exaclty where can i find information on how to do it?

I´m not the programmer, I´m the guy who will create the documentantion for the end user...

I need a little more help to undestand better this great product....

Thanks a lot...


Look at PivotCube VCL user's guide section "4.4.4 Calculated measures"
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am


Return to PivotCube ActiveX

Who is online

Users browsing this forum: No registered users and 4 guests

cron