Prob in pivot table

[nikhilgarg]

Hey,

In my attached application, for unknown region in pivot table there are shown 4 Names but when i select Desk as Unknown from list box it is showing only 2 names. Pls help.

Thanks

[nikhilgarg]

Can you plz elaborate.

Thanks

[nikhilgarg]

do you mean to say that:

Table1:

Mapping Load

Name,

isnull(Desk,'Unknown', Desk) as Desk

Is it you mean?

[buzzy996 · Accepted solution]

just replace this code in ur Main 4  tab with table2,

Table2:

Mapping LOAD isnull(Name,'Unknown', Name) as Name,

     Desk

FROM

(ooxml, embedded labels, table is Sheet1);

[nikhilgarg]

Thankx buddy, it helps. I just needed to shift my calculated dimension code to script side

[nikhilgarg]

Can you help me regarding my other prob?

I have one dashboard in Dev server and QA server. My dev server dashboard reloads everyday but QA server dashboard doesnot reload everyday. I want it to reload everyday. What to do for this?

[buzzy996]

if I'm not understand wrongly,u can schedule ur dashboard on ur QA Server.

[nikhilgarg]

Can you tell me how?

Becoz in DEV server , i see in QMC, there is specified the reload time for

evryday and at that time dashboard is being reload on DEV server. Does QMC

reload setting is different for QA server? Do i need to check QMC setting

in QA also ?

[buzzy996]

yes, first u have to confirm the application is deployed on network drives and configured accordingly the setting in ur both the servers or not?

if ur application is placed in ur local box then the setting will be different on both the server's.

[nikhilgarg]

Ohk but i just want to confirm that am i using correct way to access QMC on QA ?

QAServername:4780/QMC  ?

Thanks