Education Software Strategy.com

Knowledge Base

Product

Community

KB274527: Google map widgets fail to trigger information windows based on panel stacks in MicroStrategy Web

Community Admin

• Strategy

When selecting a marker on Google map, it appears that the selected data is loading; however, the information window never appears

SYMPTOM:
Using a panel stack as an information window for a Google map widget does not work in Strategy Web 10.1. When selecting a marker on the map, it appears that the selected data is loading; however, the information window never appears, as shown below.

Using the Google map widget as a selector for the panel stack works as designed if the panel stack is not set to be used as an information window, as seen below.

STEPS TO REPRODUCE:

Create an Excel spreadsheet containing the following table.

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

<?xml version='1.0'?>
<!DOCTYPE fontconfig SYSTEM 'fonts.dtd'>
<fontconfig>
<match target="font">
<edit mode="assign" name="antialias">
<bool>true<bool>
</edit>
</match>
</fontconfig>
SQL after fix


create table T7RTQ22AEOP000 nologging as
select    distinct a12.CUST_CITY_ID  CUST_CITY_ID,
    a13.CALL_CTR_ID  CALL_CTR_ID,
    a11.QUARTER_ID  QUARTER_ID
from    LU_MONTH    a11
    join    CITY_MNTH_SLS    a12
      on     (a11.MONTH_ID = a12.MONTH_ID)
    join    CITY_CTR_SLS    a13
      on     (a12.CUST_CITY_ID = a13.CUST_CITY_ID) 
...
select    pa14.YEAR_ID  YEAR_ID,
    avg((a11.TOT_COST - a13.TOT_COST))  WJXBFS1
from    QTR_CATEGORY_SLS    a11
    join    T7RTQ22AEOP000    pa12
      on     (a11.QUARTER_ID = pa12.QUARTER_ID)
    join    CITY_CTR_SLS    a13
      on     (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and 
    pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
    join    TCM8D230MOP001    pa14
      on     (a11.QUARTER_ID = pa14.QUARTER_ID)
group by    pa14.YEAR_ID
...

Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 CertifiedCityLatitudeLongitudeProfitWashington D.C.38.9047-77.0364819231New York City40.7127-74.006912932Los Angeles34.05-118.24459203

Create a new blank document.
Click on Add External Data to access Data Import and import the Excel file created in step 1.
Create a Report Services document with the newly created Data Import cube.
Add City, Latitude, Longitude, and Profit to a grid.
Right-click on the grid > Properties and Formatting.
Set the widget type to Google Map by going to Widget > DHTML > Google Map.
Open the Widget Properties.
Set the 'Use attribute or form' setting to 'Use Attribute'.
Change the 'latitude' option to "Latitude", 'longitude' to "Longitude", and 'display attribute' to "City".
Press Ok twice to close the Properties and Formatting window.
Insert a Panel stack.
Add a grid to the panel stack containing City and Profit.
Right-click on all of the attributes in the widget grid, one at a time, and select Use as selector for all of them.
Right-click on the panel stack and open the Properties and Formatting window.
Check the 'Use as Information Window' setting and press OK.
Run the document in Presentation mode.
Click on a marker and notice that it appears to load data, but the information window never appears.

CAUSE:
This is an identified defect in Strategy Web 10.1.

ACTION:
Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release.

0 comments

Details

Knowledge Article

Published:

April 6, 2017

Last Updated:

April 6, 2017