Hi Plamen,

Since the business objects are not known during design time, I would need this during runtime. Here is my code, but it does not work:

        public FlatDataSource CreateDataSource(List<Dictionary<object, object>> list, ObservableCollection<string> texts)
        {
            FlatDataSource flatDataSource = new FlatDataSource();

// this creates an IEnumerable from the list<dictionary<object,object>>

           flatData = DataSourceCreator.ToDataSource(list);
            flatDataSource.ItemsSource = flatData;

            CubeMetadata csettings = new CubeMetadata { DataTypeFullName = flatData.GetType().ToString(), DisplayName = "DisplayNameXYZ" };

// go through the first dictionary to get the property names from the keys

           int i = 0;
            foreach (KeyValuePair<object, object> pair in list[0])
            {
                DimensionMetadata dm = new DimensionMetadata();
                dm.DisplayName = texts[i];
                dm.SourcePropertyName = pair.Key.ToString();
                csettings.DimensionSettings.Add(dm);
                i++;

            }

            flatDataSource.CubesSettings.Add(csettings);

...

}

The name of the cube is still equal to the name of the type and the texts are still equal to the field names. What do I do wrong?

Many thanks and best regards,

Tamás

Hi Tamas,
Could you try to set this line of code at the end of you assignments:
flatDataSource.ItemsSource = flatData;

because the routine of metadata examining is started when ItemsSource is changed.

Let me know if that works for you.
Plamen.

Dear Plamen,

Thank you very much, it works fine. It was the fullname that was not correct. Thanks for your help!

Have a nice day,

Tamás

Hello,

What is the type of flatData instance? I think that is your IEnumerable that you use as data source. As DataTypeFullName you need to pass the full type name of items stored into the IEnumerable. If your data source is an IEnumerable<T> you need to pass typeof(T).FullName:

CubeMetadata csettings = new CubeMetadata { DataTypeFullName = typeof([Your Items Type Here])ToString(), DisplayName = "DisplayNameXYZ" };

Plamen.

Hi Plamen,

Now it does not give an error, but the texts are still not changed. Here is my code:

            CubeMetadata csettings = new CubeMetadata { DataTypeFullName = flatData.GetType().ToString(), DisplayName = "DisplayNameXYZ" };

            int i = 0;
            foreach (KeyValuePair<object, object> pair in list[0])
            {
                DimensionMetadata dm = new DimensionMetadata();
                dm.DisplayName = texts[i];
                dm.SourcePropertyName = pair.Key.ToString();
                csettings.DimensionSettings.Add(dm);
                i++;

            }

            FlatDataConnectionSettings flatDataSettings = new FlatDataConnectionSettings();
            FlatDataSource flatDataSource = new FlatDataSource { ConnectionSettings = flatDataSettings };
            flatDataSource.CubesSettings.Add(csettings);
            flatDataSource.ItemsSource = flatData;

Maybe the problem is with this line:

new CubeMetadata { DataTypeFullName = flatData.GetType().ToString(), DisplayName = "DisplayNameXYZ" };

What exactly should be in DataTypeFullName? Maybe flatData.GetType().ToString() is not exactly what is needed.

Thanks and best regards,

Tamás

Ok,

Try to initalize FlatDataSource in thos way:

FlatDataConnectionSettings flatDataSettings =

    new FlatDataConnectionSettings();

FlatDataSource flatDataSource =

    new FlatDataSource

        {

            ConnectionSettings = flatDataSettings

Hi Plamen,

Unfortunately if I add this to the end then I got an error at this line,

            flatDataSource.CubesSettings.Add(csettings);

because flatDataSource.CubesSettings is null. I cannot create it,

            flatDataSource.CubesSettings = new List<CubeMetadata>();

since it is read only.

Thanks and best regards,

Tamás