OLAPCopyDataArea with to a cube with more dimension

Hi all,

can anybody please provide an example how to use OLAPCopyDataArea with different dimensionality?

I always get error for the definition of the source data area. I understand, that i have to specivy an empfy string in the source dimension list, but how is this dimension that is not available in the source cube defined in the source Elements?

Tried these in the StringListList at the position of the missing dimension:

Append(sourceElements, "");

Append(sourceElements, ConvertToStringList(""));

Append(sourceElements, ConvertToStringList(OlapDataAreaBCells));

But all are raising error at time of executing the OLAPCopyDataArea

Thanks for any help how to define the sourceElements correctly

Ralf

Find more posts tagged with

Infor EPM Discussions

Comments

Llorenç Tomas

Hi Ralf, I guess the problem comes because you have to use the keyword 'OlapDataAreaBCells' that means all the base values instead of blanks, I give you an example:

StringList Version_F=ConvertToStringList(p_VersionF);
StringList Version_T=ConvertToStringList(p_VersionT);
StringList Month_F=ConvertToStringList(p_MonthF);
StringList Month_T=ConvertToStringList(p_MonthT);
StringList Year_F=ConvertToStringList(p_YearF);
StringList Year_T=ConvertToStringList(p_YearT);
StringList Entity=ConvertToStringList(OlapDataAreaBCells);if (p_Entity != "Group Companies") {Entity=ConvertToStringList(p_Entity);}
StringList Raw = ConvertToStringList(OlapDataAreaBCells);
StringList Family = ConvertToStringList(OlapDataAreaBCells);
StringList MeasureRaw = ConvertToStringList("Budget Percentage");

Append(sourceElements, Year_F);
Append(sourceElements, Month_F);
Append(sourceElements, Version_F);
Append(sourceElements, Entity);
Append(sourceElements, Family);
Append(sourceElements, Raw);
Append(sourceElements, MeasureRaw);

Append(targetElements, Year_T);
Append(targetElements, Month_T);
Append(targetElements, Version_T);
Append(targetElements, Entity);
Append(targetElements, Family);
Append(targetElements, Raw);
Append(targetElements, MeasureRaw);

OLAPDataArea localValues = OLAPCreateDataArea(olapconnection, "Raw",
OlapDataAreaIncludeB | OlapDataAreaSuppressNull, OlapDataAreaOperatorNotEqual,
0, OlapDataAreaOperatorNone, 0, sourceElements);

OLAPCopyDataArea(localValues, "Raw", "Relative", factor, targetElements, sourceElements, false, true);

Kind Regards

Ralf Zerfass

Hi Lorenzo,

your example has the same dimensionality in source and target cubes. That's working find on my side as well.

The challenge is how to copy to a cube that has one additional dimension that has to filled with a constant value.

Ralf

Llorenç Tomas

Hi Ralf, I misunderstood you, sorry, I frankly don't know whether you can copy from 'ALL' to one specific value in the same dimension, anyway you can try putting 'OlapDataAreaBCells' in the source and a specific value in the target,

That would be like this, pay attention to Version_F (From) and Version_T (to):

StringList Version_F=ConvertToStringList(OlapDataAreaBCells);
StringList Version_T=ConvertToStringList(p_VersionT);
StringList Month_F=ConvertToStringList(p_MonthF);
StringList Month_T=ConvertToStringList(p_MonthT);
StringList Year_F=ConvertToStringList(p_YearF);
StringList Year_T=ConvertToStringList(p_YearT);
StringList Entity=ConvertToStringList(OlapDataAreaBCells);if (p_Entity != "Group Companies") {Entity=ConvertToStringList(p_Entity);}
StringList Raw = ConvertToStringList(OlapDataAreaBCells);
StringList Family = ConvertToStringList(OlapDataAreaBCells);
StringList MeasureRaw = ConvertToStringList("Budget Percentage");

OLAPDataArea localValues = OLAPCreateDataArea(olapconnection, "Raw",
OlapDataAreaIncludeB | OlapDataAreaSuppressNull, OlapDataAreaOperatorNotEqual,
0, OlapDataAreaOperatorNone, 0, sourceElements);

OLAPCopyDataArea(localValues, "Raw", "Relative", factor, targetElements, sourceElements, false, true);

Kind Regards,

Ralf Zerfass

Thanks again, but still not what I need.

OLAPCopyDataArea has an overloaded definition with two more parameters for sourceDimensions and targetDimensions additionally to the source/targetElements, as described in the documentation.

Cube A has 8 dimensions, Cube B has this eight plus one more dimension. The 9th dimension in the target cube should be filled with a constant value. According to documentation this should work, but unfortunately there is no example for this case given...

I'm sorry, I can't share my code example easily, as this is on the customers client., whereas this thread is running on my personal laptop.

ivan-rebo

Append(sourceElements, ""); should be the correct one. Just make sure its position matches the dimension in the target elements that doesnt exist in the source cube and make sure its maping to exactly one element on that target dimension.

Ralf Zerfass

Hi Ivan,

that's what I thought, too, but either does not work as described or I'm doing something wrong:

Here the details:

Source-Cube

Target-Cube with one extra dimension:

BI#-Code

string from_cube = "MAR_Projects";
    string to_cube = "MAR_7YP";


    // 2. Create string list for target data area

    StringList targetDimensions = CreateStringList();
    Append(targetDimensions, "7YPID");
    Append(targetDimensions, "Month");
    Append(targetDimensions, "Project");
    Append(targetDimensions, "Version");
    Append(targetDimensions, "Source");
    Append(targetDimensions, "Unit");
    Append(targetDimensions, "Product");
    Append(targetDimensions, "Market");
    Append(targetDimensions, "Measure");

    StringListList targetElements = CreateStringListList();
    StringList slYPID = ConvertToStringList("2");
    StringList slMonth = ConvertToStringList(OlapDataAreaBCells);
    StringList slProject = ConvertToStringList("42");
    StringList slVersion = ConvertToStringList("2");
    StringList slSource = ConvertToStringList(OlapDataAreaBCells);
    StringList slUnit = ConvertToStringList(OlapDataAreaBCells);
    StringList slProduct = ConvertToStringList(OlapDataAreaBCells);
    StringList slMarket = ConvertToStringList(OlapDataAreaBCells);
    StringList slMeasure = ConvertToStringList(OlapDataAreaBCells);

    Append(targetElements, slYPID);
    Append(targetElements, slMonth);
    Append(targetElements, slProject);
    Append(targetElements, slVersion);
    Append(targetElements, slSource);
    Append(targetElements, slUnit);
    Append(targetElements, slProduct);
    Append(targetElements, slMarket);
    Append(targetElements, slMeasure);

    // 3. Create string list for source data area
    StringList sourceDimensions = CreateStringList();
    Append(sourceDimensions, "");
    Append(sourceDimensions, "Month");
    Append(sourceDimensions, "Project");
    Append(sourceDimensions, "Version");
    Append(sourceDimensions, "Source");
    Append(sourceDimensions, "Unit");
    Append(sourceDimensions, "Product");
    Append(sourceDimensions, "Market");
    Append(sourceDimensions, "Measure");

    StringListList sourceElements = CreateStringListList();

    Append(sourceElements, "");
    Append(sourceElements, slMonth);
    Append(sourceElements, slProject);
    Append(sourceElements, slVersion);
    Append(sourceElements, slSource);
    Append(sourceElements, slUnit);
    Append(sourceElements, slProduct);
    Append(sourceElements, slMarket);
    Append(sourceElements, slMeasure);

    // 4. Delete all existing values in the target area.
    // Filter data area to values that are not null (suppress null values). Use base elements only
    OLAPDataArea deleteValues = OLAPCreateDataArea(oConnection, to_cube,
                                                   OlapDataAreaIncludeB | OlapDataAreaSuppressNull, OlapDataAreaOperatorNone,
                                                   0.0, OlapDataAreaOperatorNone, 0, targetElements);

    OLAPDeleteDataArea(deleteValues);


    // 5. Filter data area to values that are not null (suppress null values). Use the base elements only
    OLAPDataArea localValues = OLAPCreateDataArea(oConnection, from_cube,
                                                  OlapDataAreaIncludeB | OlapDataAreaSuppressNull, OlapDataAreaOperatorNone,
                                                  0.0, OlapDataAreaOperatorNone, 0, sourceElements);


    // 6. Copy Data area
    OLAPCopyDataArea(localValues, to_cube, "Relative", 1.0, targetDimensions, targetElements, sourceDimensions, sourceElements, true, true);

The elements 42 in the project- and 2 in the version dimension exist and everything runs fine when the final OLAPCopyDataArea is set to comment, but when the process runs as shown above, it results in the following error:

Any idea why?

As I'm on vacation for the next two weeks, no hurry on this, but looking forward using the function to copy between two cubes with different dimensionality one day...

Ralf

ivan-rebo

sorry i got confused before. I think the correct is adding "" to sourceDimensions and empty stringlist to sourceElements !

Append(sourceElements, CreateStringList());

0911060553270289.pdf

Ralf Zerfass

Thanks, Ivan,

I'll give it a try, when back from holidays and let you know.

BR,

Ralf

Copyright © 2025 Infor. All rights reserved.