ListManager.CreateFromDWCalc Method (PIA)

  • Article

Use this method to create a list from an Analysis report.

Definition

[Visual Basic .NET]

Imports Microsoft.CommerceServer.Interop.Targeting
…
Public Function CreateFromDWCalc(listName As String,
 listDesc As String,
 lFlags As Integer,
 userFlags As Integer,
 DWConnStr As String,
 OLAPConnStr As String,
 ReportStatusId As String,
 bAsync As Integer,
 Optional ByRef pvarOpID As Object) As Object

[C#]

using Microsoft.CommerceServer.Interop.Targeting;
…
public object CreateFromDWCalc(stringlistName,
 stringlistDesc,
 intlFlags,
 intuserFlags,
 stringDWConnStr,
 stringOLAPConnStr,
 stringReportStatusId,
 intbAsync,
 ref objectpvarOpID);

Parameters

[Visual Basic .NET]

  • listName
    A String that provides the name for the new list.
  • listDesc
    A String that provides a description for the new list.
  • lFlags
    An Integer that specifies the bitmask flags that control the type of list created.
  • userFlags
    An Integer that contains application-specific user flags. Not used by the ListManager object.
  • DWConnStr
    A String that contains the connection string for the Data Warehouse.
  • OLAPConnStr
    A String that contains the OLAP connection string.
  • ReportStatusId
    A String that contains the ReportStatusID of the report to be imported.
  • bAsync
    An Integer that specifies whether the creation operation is performed synchronously or asynchronously. A value of 1 indicates asynchronous processing.
  • pvarOpID
    An optional Object used to return an Operation ID.

[C#]

  • listName
    A string that provides the name for the new list.
  • listDesc
    A string that provides a description for the new list.
  • lFlags
    An int that specifies the bitmask flags that control the type of list created.
  • userFlags
    An int that contains application-specific user flags. Not used by the ListManager object.
  • DWConnStr
    A string that contains the connection string for the Data Warehouse.
  • OLAPConnStr
    A string that contains the OLAP connection string.
  • ReportStatusId
    A string that contains the ReportStatusID of the report to be imported.
  • bAsync
    An int that specifies whether the creation operation is performed synchronously or asynchronously. A value of 1 indicates asynchronous processing.
  • pvarOpID
    A reference to an object used to return an Operation ID.

Return Values

[Visual Basic .NET] If this method completes successfully, it returns an Object that contains the ID of the new list.

[C#] This method returns a reference to an object used to return the ID of the new list.

Exceptions

This method may throw one of many mapped exceptions or an exception of type COMException. See Standard COM Errors for additional details.

[Visual Basic .NET]

The following table shows the custom COM errors that a COMException can wrap.

Value Description
&H8C400001 Failed to establish database connection.
&H8C400017 Unable to create the object.
&H8C400005 Invalid flags value.
&H8C400007 The specified list has already been created.
&H8C40000D The list is designated as a Mailable list but does not contain an rcp_email column.
&H8C40000B The operation was canceled.
&H8C40001A The report rendering object failed during Analysis report export to List Manager. See the Application event log message logged by that object describing the problem.
&H8C400003 Error while executing SQL/ADO operation.
&H8C40000E The list is designated as a User list but does not contain an rcp_guid column.
&H80040007 The ListManager object has not been properly initialized.

[C#]

The following table shows the custom COM errors that a COMException can wrap.

Value Description
0x8C400001 Failed to establish database connection.
0x8C400017 Unable to create the object.
0x8C400005 Invalid flags value.
0x8C400007 The specified list has already been created.
0x8C40000D The list is designated as a Mailable list but does not contain an rcp_email column.
0x8C40000B The operation was canceled.
0x8C40001A The report rendering object failed during Analysis report export to List Manager. See the Application event log message logged by that object describing the problem.
0x8C400003 Error while executing SQL/ADO operation.
0x8C40000E The list is designated as a User list but does not contain an rcp_guid column.
0x80040007 The ListManager object has not been properly initialized.

Remarks

This method calls into the ReportRender object, passing it the DWConnStr, OLAPConnStr, and ReportStatusId parameters along with a connection string to the database used by the ListManager object, and the table name that it should create.

For a list of possible values for the lflags parameter, see the GetListFlags method.

[Visual Basic .NET]

Example

' oListID is an Object
oListID = oListManager.CreateFromDWCalc("TequillaBuyers1", _
 "Tequilla buyers in January", 20, 0, "URL=mscop:" & _
 "//InProcConnect/Server=myserver:Database=dbname:" & _
 "Catalog=DWSchema:  Trusted_Connection=Yes:FastLoad=True", _
 "2B54480041694C4987131B794078B4C9", 0)

Requirements

Namespace: Microsoft.CommerceServer.Interop.Targeting

Platforms: Windows 2000, Windows Server 2003

Assembly: listmanagerlib (in listmanagerlib.dll)

See Also

ListManager Class

Copyright © 2005 Microsoft Corporation.
All rights reserved.