Error loading analysis with filter

Posted by: bradwery on 3 August 2017, 4:04 pm EST

  • Posted 3 August 2017, 4:04 pm EST

    I created a new analysis and added information to the Filter Card. I then saved the layout (using XML). When I try to load the XML that I saved previously, I get the following exception:

    An exception of type \'GrapeCity.ActiveAnalysis.InvalidLayoutException\' occurred in GrapeCity.ActiveAnalysis.Web.dll but was not handled in user code

    Additional information: DataSource is not specified or invalid.

    Inner Exception:

    \"Members can not be excluded due of some restrictions.\"

    My data source is set and connected properly. It\'s the exact same data source used to initially create the analysis so I know it works and it\'s the right one. This is essentially what I\'m doing to load the analysis control:

    var myDS = new MdxDataSource();
    myDS.ConnectionString = \"...\"
    PivotView1.DataSource = myDS;
    System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(new StringReader(analysisXml));
    PivotView1.Read(xmlReader, PersistSettings.Layout | PersistSettings.CardLayout);

    Why would I be getting this error?

  • Replied 3 August 2017, 4:04 pm EST


    This error generally occurs when datasource is changed between saving the layour and uploading the layout. I tried to replicate the issue in the product sample by saving the layout after applying filter, clear the PivotView and then, reload the layout but it worked correctly at my end. The default sample is available at this link:


    Could you kindly check with the same and let me know if I missed any step ? Else, share a small sample replicating the issue so that I can suggest accordingly.

    I tested it with 953 build available at :

  • Marked as Answer

    Replied 3 August 2017, 4:04 pm EST

    Thanks a lot. I got it to work.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels