Multi-value facets?? How to do

Jan 13, 2011 at 9:42 PM

With the excel tool you can specify multiple values in a column by seperating the values with a '||'.  This does not appear to work with the pAuthor tool.  How do I accomplish this functionality with this tool?


Example:  I have a "Products" column that lists all the products a solution requires to run.  currently in my excel spreadsheet that column make look like this "Windows Server 2008 R2 || SQL Server 2008 || IE 8"  and when I use the Excel tool the CXML for "products" looks like this and the PivotViewer control handles it correctly:


<Facet Name="Products">

    <String Value="Windows Server 2008 R2" />

    <String Value="SQL Server 2008" />

    <String Value="IE 8" />



With pAuthor it looks like this:

<Facet Name="Products">

    <String Value="Windows Server 2008 R2 || SQL Server 2008 || IE 8" />


Do I need to do it different for pAuthor?

Jan 14, 2011 at 10:16 PM

I also encountered this issue and found the solution in the documentation (Pivot Collection Tool Command Line User's Guide), available with the download. The documentation indicates that a new line should be used as the separator for multiple values. Press Alt-Enter in Excel to insert a new line within a cell. I tested this and it works for me.