Requirement.

[deepakqlikview_123]

Hello Team,

Please find attachment.

I need to prepare dashboard for mentioned detail in excel.

Can you plesase tell me how the data should be formatted for this.

Moreover also suggest what would be dimensions and measures.

Thanks.

[its_anandrjs]

Load your table this way

Directory;

LOAD

     //F1,

     Title,

     //F3,

     [CDMS AUDIT LOG Size GB],

     //F5,

     [CDMS WSS CONTENT Size GB],

     //F7,

     [CDMSLive DATABASE Size GB],

     //F9,

     [LOG size CDMS AUDIT LOG Size GB],

     //F11,

     [LOG size CDMS WSS CONTENT Size GB],

     //F13,

     [LOG size CDMSLive Database Size GB],

     //F15,

     [Server (Available Space)],

     //F17,

     [Application Server-II 122 (465 GB)],

     //F19,

     [Application Server-I 123 (465 GB)],

     //F21,

     [Database Server 124  (C: 1.08 TB, 😧 464 GB, E: 464 GB)],

     //F23,

     [Database Mirror Server 125 (C: 1.08 TB, 😧 464 GB, E: 464 GB)]

     //F25,

     //F26,

     //F27

FROM

[Task details for 3 March 2014.xlsx]

(ooxml, embedded labels, table is CDMS, filters(

Transpose()

));