Tuesday, April 9, 2013

Tableau Server 8 Permissions

Here's an initial dashboard showing the Tableau Server 8 permissions. There are some additions from TS 7 to enable Web authoring.


As usual, the descriptions are truncated to the first 255 characters, an artifact of Tableau's use of the MS Jet engine for accessing Excel and CSV data. I'm planning on creating a proper Tableau Extract for the data using the new extract API, but it seemed prudent to not hold this back for that.

2 comments:

  1. Try to put a fake first record (line) with every column containting a string of characters the size of the maximum length to be see in your data set. If the longuest string for the column "Remark" is 5421 characters, put on the first line a string of 5421 characters of your choice (I suggest "x"). You can also sort your dataset so all the longuest string is on the first 20 lines or so.

    Bruno Dionne - University Laval

    ReplyDelete
  2. If it's still don't work you can add this registry option to change MSJET behavior.
    MSJET read only some first lines to guess column length, These registry option tell Windows to read all lines to guess the correct column length. Off course you will have a performance penalty on big Excel file to import, as Windows need to read all lines twice, first read to set correct column length and second to read data into Tableau.

    Tested with Excel 2010 and Tableau 7.0


    Bruno Dionne - University Laval



    Windows 7 64 bits :
    -------------------

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Excel]
    "TypeGuessRows"=dword:00000000

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines\Excel]
    "TypeGuessRows"=dword:00000000


    Windows 2008 server 64 bits :
    -----------------------------
    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Excel]
    "TypeGuessRows"=dword:00000000


    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\Engines\Excel]

    "TypeGuessRows"=dword:00000000

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines\Excel]
    "TypeGuessRows"=dword:00000000


    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\Engines\Excel]
    "TypeGuessRows"=dword:00000000





    ReplyDelete