Conteúdos da sessão do TechDays 2010 “Microsoft Business Intelligence no Office 2010”

Como prometido aqui estão conteúdos da minha sessão no TechDays 2010 sobre Business Inteligence na plataforma Office 2010.

Slides: http://cid-5d0350bbe4220916.skydrive.live.com/self.aspx/Public/TechDays%202010/TechDays%202010%20-%20Microsoft%20Business%20Intelligence%20no%20Office%202010.pptx

Demos: http://cid-5d0350bbe4220916.skydrive.live.com/self.aspx/Public/TechDays%202010/TechDays%202010%20-%20Microsoft%20Business%20Intelligence%20no%20Office%202010%20Demos.zip

Gostava também de agradecer a todos os que estiveram presentes e espero que tenham gostado de assistir à sessão tanto como eu gostei de-a preparar 🙂

Por razões de espaço não me é possível colocar as demos e bits das demos de Performance Point 2010 pois para colocarem a funcionar teriam que ter: os bits de performance point, o data warehouse e a base dados olap.

O Zip file é composto pelo seguinte:

  • Visio Services
    • Network Status.vdx
      • Diagrama Visio que foi demonstrado na demo de visio services
    • VisioServices_Search.html
      • Código html com javascript que permite o search & highlight sobre um diagrama visio na web com visio services no sharepoint 2010
  • Excel Services
    • AnaliseVendas.xlx
      • Dashboard construido em Excel, sobre o a base dados AdventureWorksDW2008R2
    • ExcelServices_SelectionEmail.html
      • Código html com javascript que permite a selecção de um range em Excel Services e envio de um email com o conteúdo seleccionado
  • PowerPivot
    • AnaliseTechDays2010.xlsx
      • Análise dos resultados das sessões do techdays com PowerPivot
    • Resultados.accdb
      • Base dados access com os resultados das sessões

Vou tentar nos próximos dias publicar aqui um post detalhado com o que demonstrei na minha sessão.

Mais uma vez um muito obrigado a todos.

Infopath 2007 Set xsi:nil on FormServices

In InfoPath 2007 the fields wich type is one of the following:

  • Whole Number (integer)
  • Decimal (double)
  • Date (date)
  • Time (time)
  • Date and Time (dateTime)

If you try to set that field value programaticaly without clearing the xsi:nil attribute you will get an “Schema validation found non-data type errors.”

For more information: http://blogs.msdn.com/infopath/archive/2006/11/28/the-xsi-nil-attribute.aspx

But if you want to later clear that field value you will need to set the xsi:nil attribute back to true.

If you try to create the attribute using the CreateAttribute, it works on the full client but it wont work on the Sharepoint Forms Server.

The only way that I found to make this work in a “clean” way was like this:

XPathNavigator nodeToClear = xDoc.SelectSingleNode(“xpathtonode”, this.NamespaceManager);

nodeToClear.ReplaceSelf(string.Format("<{0} xsi:nil=’true’/>", nodeToClear.Name));

Hope it helps…

Alternative to Caml string building

Hi,
I’ve been using a nice Caml Builder that is used by the U2U Caml Builder(The most popular tool among the SharePoint developers) .

Its very easy to use and in my opinion a lot more secure and efective than manual writing the CAML.

For example if i want to do a simple query to get an item by a column, i’ll do something like this:
CamlBuilder batchBuilder = new CamlBuilder(CamlTypeEnum.GetListItems);
batchBuilder.AddWhereField("", DataTypeEnum.Text, CamlOperatorEnum.Eq, CamlCombinerEnum.And, out addCombinerTag);
SpWsListsProxy.GetListItems(listName, string.Empty, batchBuilder.QueryNode, null, "1", null, null);

Note: I’am not disposing the proxy for simplicity of code
In "batchBuilder.QueryNode" it will be the query xml without errors and it is assured that it will work…
If you want you can do a reverse engineer on the dll and copy the code to your own sharepoint framework if you like, it is no ofuscated…

For more information:
http://www.u2u.info/Blogs/karine/Lists/Posts/Post.aspx?List=d35935e0%2D8c0e%2D4176%2Da7e8%2D2ee90b3c8e5a&ID=13