Shawn Weisfeld [MVP] - All Comments

Die Code-Zentrale » Blog Archive » schneller Zugriff auf Bitmaps, Manipulation von Bitmaps

Thu, 02 Oct 2008 11:17:10 GMT

Pingback from Die Code-Zentrale » Blog Archive » schneller Zugriff auf Bitmaps, Manipulation von Bitmaps

Leistung von Visual Basic verbessern - EntwicklerGemein.de

Leistung von Visual Basic verbessern - EntwicklerGemein.de — Sat, 27 Sep 2008 11:53:35 GMT

Pingback from Leistung von Visual Basic verbessern - EntwicklerGemein.de

Free .NET Hosting for User Groups | Legal Webmastering

Free .NET Hosting for User Groups | Legal Webmastering — Sat, 30 Aug 2008 12:03:05 GMT

Pingback from Free .NET Hosting for User Groups | Legal Webmastering

re: Using XML\A and C# to Query SAP BW

schwinbp — Wed, 06 Aug 2008 15:23:29 GMT

Shawn,

Great and helpful article. I have one question on the Xml that comes back from SAP(like below). The problem is that the descriptive column names are in the Schema section and the column names in the actual xml are in a "C00000#" format.

How do I would convert this data into a DataSet or DataTable object that has the columns named with the names in the schema?

<root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:xsi="www.w3.org/.../XMLSchema-instance">">www.w3.org/.../XMLSchema-instance">

<xsd:schema xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:sql="urn:schemas-microsoft-com:xml-sql" elementFormDefault="qualified">

<xsd:element name="root">

<xsd:complexType>

<xsd:sequence minOccurs="0" maxOccurs="unbounded">

<xsd:element name="row" type="row" />

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:simpleType name="uuid">

<xsd:restriction base="xsd:string">

<xsd:pattern value="[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}" />

</xsd:restriction>

</xsd:simpleType>

<xsd:complexType name="row">

<xsd:sequence minOccurs="0" maxOccurs="unbounded">

<xsd:element name="C000000" type="xsd:string" sql:field="[ZFISQUART].[LEVEL01].[MEMBER_CAPTION]" />

<xsd:element name="C000001" type="xsd:string" sql:field="[ZDBBUS].[LEVEL01].[MEMBER_CAPTION]" />

<xsd:element name="C000002" type="xsd:string" sql:field="[Measures].[ZDBOPINC]" />

<xsd:element name="C000003" type="xsd:string" sql:field="[Measures].[ZDBORONA]" />

<xsd:element name="C000004" type="xsd:string" sql:field="[Measures].[ZDBORONAR]" />

<xsd:element name="C000005" type="xsd:string" sql:field="[Measures].[ZDBNETASS]" />

</xsd:sequence>

</xsd:complexType>

</xsd:schema>

<row><C000000>FY04Q1</C000000><C000001>Sales</C000001><C000002>10,000.00 USD</C000002><C000003>0.000</C000003><C000004>0.000</C000004><C000005>100,000.00 USD</C000005></row>

<row><C000000>FY04Q1</C000000><C000001>Marketing</C000001><C000002>1,200.00 USD</C000002><C000003>0.000</C000003><C000004>0.000</C000004><C000005>125,000.00 USD</C000005></row>

</root>

Vicodin.

No prescription vicodin. — Wed, 30 Jul 2008 08:05:10 GMT

Vicodin. Vicodin withdrawal.

Dependency ultram.

Ultram. — Mon, 21 Jul 2008 16:58:52 GMT

Ultram. Order ultram no prescription. Tramadol ultram and acute pain.

2 Static » Blog Archive » 2 Static ?? Blog Archive ?? 2 Static ?? Blog Archive ?? Generics …

Sun, 08 Jun 2008 18:07:55 GMT

Pingback from 2 Static » Blog Archive » 2 Static ?? Blog Archive ?? 2 Static ?? Blog Archive ?? Generics …

2 Static » Blog Archive » 2 Static ?? Blog Archive ?? Generics , Extension Methods, and XML …

Sat, 07 Jun 2008 01:29:49 GMT

Pingback from 2 Static » Blog Archive » 2 Static ?? Blog Archive ?? Generics , Extension Methods, and XML …

2 Static » Blog Archive » Generics , Extension Methods, and XML Serialization

2 Static » Blog Archive » Generics , Extension Methods, and XML Serialization — Fri, 06 Jun 2008 00:55:47 GMT

Pingback from 2 Static » Blog Archive » Generics , Extension Methods, and XML Serialization

re: Using XML\A and C# to Query SAP BW

johni2i — Tue, 22 Apr 2008 13:26:31 GMT

Hi,

I'm trying to integrate a SAPBW connection into my .net website using a SAPBW xml/a adapter. (I've added a web reference to this so I have a .wdsl).

However, I'm stuck with step 3 which shows how to implement the solution for an application rather then a website so it talks about modify the generated webservice proxy??

"Step 3: Modify the WebService Proxy Class, When .NET generates the proxy class it declares the Execute Mehtod with two arguments the ExecuteCommand and a PropertiesType. The PropertiesType is a base class for the DiscoverProperties object, but has no properties. To fix this we actually want to pass a DiscoverProperties object to the Execute Method. While this compiles fine the XML serializer has a problem serializing the request. To fix this add "[XmlElement(typeof(DiscoverProperties))]" before the PropertiesType argument in the Execute Methods Signature. It should look like this "public System.Xml.XmlElement Execute([System.Xml.Serialization.XmlElementAttribute(IsNul lable=true)] ExecuteCommand Command, [XmlElement(typeof(DiscoverProperties))]PropertiesType Properties) {"

How do I make this sort of change in a .net website. Do I need to modify the webreference wdsl file?

Any help would be very much appreciated because I can't seem to get over this... (please find my code below).

Imports System

Imports System.Data

Imports System.Xml

Imports System.Collections.Generic

Imports System.Text

Imports System.Net

Imports Microsoft

Imports SAPBW

Imports Microsoft.AnalysisServices.AdomdClient

Imports System.Xml.Serialization

Imports System.Xml.Schema

Imports System.IO

'Namespace SAPBW

<XmlInclude(GetType(_Default))> _

<XmlInclude(GetType(PropertiesType))> _

<XmlInclude(GetType(DiscoverProperties))> _

Partial Class _Default

Inherits System.Web.UI.Page

'Global Variables

Private BWQuery As MsXmlAnalysis

Private Command As ExecuteCommand

Private result As XmlElement

Private convert_result As XmlNodeReader

Private properties As DiscoverProperties

'Private properties As PropertiesType

Private login As NetworkCredential

Private cellset_result As CellSet

Private tuples_on_columns As TupleCollection

Private i As Integer

Private nr_tuples_on_columns As Integer

Protected UN As String = "UserName"

Protected Pass As String = "PassWord"

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

InitializeVariables()

SetVariables()

WriteCommand()

Commands()

End Sub

Private Sub InitializeVariables()

BWQuery = New MsXmlAnalysis()

Command = New ExecuteCommand()

properties = New DiscoverProperties()

properties.PropertyList = New DiscoverPropertiesPropertyList()

End Sub

Private Sub SetVariables()

BWQuery.Credentials = login

BWQuery.PreAuthenticate = True

properties.PropertyList.Content = "SchemaData"

properties.PropertyList.Format = "Multidimensional"

properties.PropertyList.DataSourceInfo = "default"

End Sub

Private Sub WriteCommand()

Command.Statement = "SELECT NON EMPTY { [Measures].[3YIJG796Q2HIRX2ZBG2MMQZNN] } ON COLUMNS, NON EMPTY {[FEEEARNER].[LEVEL01].ALLMEMBERS } ON ROWS FROM [OP_CTIM3/FI_CTIM3_001_V01]"

End Sub

Private Sub Commands()

'Dim s As XmlSerializer = new XmlSerializer(typeof(result))

'<XmlElement(typeof(DiscoverProperties))>

Try

Dim propType As PropertiesType

/************************************************** ******

**This is the problem as Execute expects (Command, Property)

**however i've populated Discoverproperties attribute but

**cannout pass it without implementing step 3. So I am trying

**to pass BWQuery.Execute(Command, properties)

************************************************** ******/

result = BWQuery.Execute(Command, propType)

convert_result = New XmlNodeReader(result)

cellset_result = CellSet.LoadXml(convert_result)

Dim i As Integer = 1

For i = 1 To nr_tuples_on_columns

Response.Write(tuples_on_columns(i).Members(0).Cap tion)

'Console.ReadLine()

Catch ex As Exception

Response.Write(ex.ToString())

End Try

End Sub

End Class

'End Namespace

re: Dallas Community Leadership Summit

calebjenkins — Mon, 18 Feb 2008 21:22:25 GMT

Hey Shawn -

It was great meeting you at the CLS. Thanks for joining us and for the great participation!

Taxes » Dallas Community Leadership Summit

Taxes » Dallas Community Leadership Summit — Fri, 15 Feb 2008 04:25:55 GMT

Pingback from Taxes » Dallas Community Leadership Summit

Dallas Community Leadership Summit | Health Insurance

Dallas Community Leadership Summit | Health Insurance — Fri, 15 Feb 2008 02:44:40 GMT

Pingback from Dallas Community Leadership Summit | Health Insurance

Free Tutorials

Free Tutorials — Tue, 12 Feb 2008 01:57:33 GMT

Pingback from Free Tutorials

re: South Florida Code Camp 2008

sweisfeld — Tue, 05 Feb 2008 00:57:01 GMT

I got some glowing praise via email, and I thought I would share.

---------------------------------

I have attended several of your presentations, the most recent at CodeCamp 2008 in Miramar. Your presentations are always well thought out, organized and informative. In my opinion your greatest strength is your ability to stay focused on the presentation and not let it get off course via questions from us. Thanks for taking the time to speak to us and I look forward to your future presentations.

Ken