Education Software Strategy.com

Knowledge Base

Product

Community

Application Security: Encryption

Community Admin

• Strategy

⟨ Back to Application Security home

Application Security - Encryption:

SSL (TLS) Links in Strategy (Overview and Links)

Library to Intelligence Server Link

Configuring TLS

TLS to SAP/HANA (Through ODBC Driver)

Encryption to Key Manager

TLS Configuration

Intelligence Server Cache Encryption

Create Trust Store for TLS Certificates

Join results; calculate Contribution and rank
select pa13.CATEGORY_ID CATEGORY_ID,
   a14.CATEGORY_DESC CATEGORY_DESC,
   pa11.SUBCAT_ID SUBCAT_ID,
   a12.SUBCAT_DESC SUBCAT_DESC,
   pa11.Revenue Revenue,
   pa13.WJXBFS1 WJXBFS1,
   ISNULL((pa11.Revenue / NULLIF(pa13.WJXBFS1, 0)), 0) WJXBFS2,
   rank () over (partition by pa13.CATEGORY_ID order by ISNULL((pa11.Revenue / NULLIF(pa13.WJXBFS1, 0)), 0) desc) WJXBFS3
into #ZZAM02
from #ZZMD00 pa11
   join LU_SUBCATEG a12
   on (pa11.SUBCAT_ID = a12.SUBCAT_ID)
   join #ZZMD01 pa13
   on (a12.CATEGORY_ID = pa13.CATEGORY_ID)
   join LU_CATEGORY a14
   on (pa13.CATEGORY_ID = a14.CATEGORY_ID)

Keep only top-ranking rows without affecting metric results
select pa11.CATEGORY_ID CATEGORY_ID,
   pa11.CATEGORY_DESC CATEGORY_DESC,
   pa11.SUBCAT_ID SUBCAT_ID,
   pa11.SUBCAT_DESC SUBCAT_DESC,
   pa11.Revenue WJXBFS1,
   pa11.WJXBFS1 WJXBFS2,
   pa11.WJXBFS2 WJXBFS3
from #ZZAM02 pa11
where (pa11.WJXBFS3 <= 1.0)

drop table #ZZMD00
drop table #ZZMD01
drop table #ZZAM02

Best Practices ⟩

Authentication ⟩

Authorization ⟩

Encryption

Web Security ⟩

Join results; calculate Contribution and rank
select pa13.CATEGORY_ID CATEGORY_ID,
   a14.CATEGORY_DESC CATEGORY_DESC,
   pa11.SUBCAT_ID SUBCAT_ID,
   a12.SUBCAT_DESC SUBCAT_DESC,
   pa11.Revenue Revenue,
   pa13.WJXBFS1 WJXBFS1,
   ISNULL((pa11.Revenue / NULLIF(pa13.WJXBFS1, 0)), 0) WJXBFS2,
   rank () over (partition by pa13.CATEGORY_ID order by ISNULL((pa11.Revenue / NULLIF(pa13.WJXBFS1, 0)), 0) desc) WJXBFS3
into #ZZAM02
from #ZZMD00 pa11
   join LU_SUBCATEG a12
   on (pa11.SUBCAT_ID = a12.SUBCAT_ID)
   join #ZZMD01 pa13
   on (a12.CATEGORY_ID = pa13.CATEGORY_ID)
   join LU_CATEGORY a14
   on (pa13.CATEGORY_ID = a14.CATEGORY_ID)

Keep only top-ranking rows without affecting metric results
select pa11.CATEGORY_ID CATEGORY_ID,
   pa11.CATEGORY_DESC CATEGORY_DESC,
   pa11.SUBCAT_ID SUBCAT_ID,
   pa11.SUBCAT_DESC SUBCAT_DESC,
   pa11.Revenue WJXBFS1,
   pa11.WJXBFS1 WJXBFS2,
   pa11.WJXBFS2 WJXBFS3
from #ZZAM02 pa11
where (pa11.WJXBFS3 <= 1.0)

drop table #ZZMD00
drop table #ZZMD01
drop table #ZZAM02

Best Practices ⟩

Authentication ⟩

Authorization ⟩

Encryption

Web Security ⟩

Join results; calculate Contribution and rank
select pa13.CATEGORY_ID CATEGORY_ID,
   a14.CATEGORY_DESC CATEGORY_DESC,
   pa11.SUBCAT_ID SUBCAT_ID,
   a12.SUBCAT_DESC SUBCAT_DESC,
   pa11.Revenue Revenue,
   pa13.WJXBFS1 WJXBFS1,
   ISNULL((pa11.Revenue / NULLIF(pa13.WJXBFS1, 0)), 0) WJXBFS2,
   rank () over (partition by pa13.CATEGORY_ID order by ISNULL((pa11.Revenue / NULLIF(pa13.WJXBFS1, 0)), 0) desc) WJXBFS3
into #ZZAM02
from #ZZMD00 pa11
   join LU_SUBCATEG a12
   on (pa11.SUBCAT_ID = a12.SUBCAT_ID)
   join #ZZMD01 pa13
   on (a12.CATEGORY_ID = pa13.CATEGORY_ID)
   join LU_CATEGORY a14
   on (pa13.CATEGORY_ID = a14.CATEGORY_ID)

Keep only top-ranking rows without affecting metric results
select pa11.CATEGORY_ID CATEGORY_ID,
   pa11.CATEGORY_DESC CATEGORY_DESC,
   pa11.SUBCAT_ID SUBCAT_ID,
   pa11.SUBCAT_DESC SUBCAT_DESC,
   pa11.Revenue WJXBFS1,
   pa11.WJXBFS1 WJXBFS2,
   pa11.WJXBFS2 WJXBFS3
from #ZZAM02 pa11
where (pa11.WJXBFS3 <= 1.0)

drop table #ZZMD00
drop table #ZZMD01
drop table #ZZAM02

Best Practices ⟩

Authentication ⟩

Authorization ⟩

Encryption

Web Security ⟩

Join results; calculate Contribution and rank
select pa13.CATEGORY_ID CATEGORY_ID,
   a14.CATEGORY_DESC CATEGORY_DESC,
   pa11.SUBCAT_ID SUBCAT_ID,
   a12.SUBCAT_DESC SUBCAT_DESC,
   pa11.Revenue Revenue,
   pa13.WJXBFS1 WJXBFS1,
   ISNULL((pa11.Revenue / NULLIF(pa13.WJXBFS1, 0)), 0) WJXBFS2,
   rank () over (partition by pa13.CATEGORY_ID order by ISNULL((pa11.Revenue / NULLIF(pa13.WJXBFS1, 0)), 0) desc) WJXBFS3
into #ZZAM02
from #ZZMD00 pa11
   join LU_SUBCATEG a12
   on (pa11.SUBCAT_ID = a12.SUBCAT_ID)
   join #ZZMD01 pa13
   on (a12.CATEGORY_ID = pa13.CATEGORY_ID)
   join LU_CATEGORY a14
   on (pa13.CATEGORY_ID = a14.CATEGORY_ID)

Keep only top-ranking rows without affecting metric results
select pa11.CATEGORY_ID CATEGORY_ID,
   pa11.CATEGORY_DESC CATEGORY_DESC,
   pa11.SUBCAT_ID SUBCAT_ID,
   pa11.SUBCAT_DESC SUBCAT_DESC,
   pa11.Revenue WJXBFS1,
   pa11.WJXBFS1 WJXBFS2,
   pa11.WJXBFS2 WJXBFS3
from #ZZAM02 pa11
where (pa11.WJXBFS3 <= 1.0)

drop table #ZZMD00
drop table #ZZMD01
drop table #ZZAM02

Best Practices ⟩

Authentication ⟩

Authorization ⟩

Encryption

Web Security ⟩

Join results; calculate Contribution and rank
select pa13.CATEGORY_ID CATEGORY_ID,
   a14.CATEGORY_DESC CATEGORY_DESC,
   pa11.SUBCAT_ID SUBCAT_ID,
   a12.SUBCAT_DESC SUBCAT_DESC,
   pa11.Revenue Revenue,
   pa13.WJXBFS1 WJXBFS1,
   ISNULL((pa11.Revenue / NULLIF(pa13.WJXBFS1, 0)), 0) WJXBFS2,
   rank () over (partition by pa13.CATEGORY_ID order by ISNULL((pa11.Revenue / NULLIF(pa13.WJXBFS1, 0)), 0) desc) WJXBFS3
into #ZZAM02
from #ZZMD00 pa11
   join LU_SUBCATEG a12
   on (pa11.SUBCAT_ID = a12.SUBCAT_ID)
   join #ZZMD01 pa13
   on (a12.CATEGORY_ID = pa13.CATEGORY_ID)
   join LU_CATEGORY a14
   on (pa13.CATEGORY_ID = a14.CATEGORY_ID)

Keep only top-ranking rows without affecting metric results
select pa11.CATEGORY_ID CATEGORY_ID,
   pa11.CATEGORY_DESC CATEGORY_DESC,
   pa11.SUBCAT_ID SUBCAT_ID,
   pa11.SUBCAT_DESC SUBCAT_DESC,
   pa11.Revenue WJXBFS1,
   pa11.WJXBFS1 WJXBFS2,
   pa11.WJXBFS2 WJXBFS3
from #ZZAM02 pa11
where (pa11.WJXBFS3 <= 1.0)

drop table #ZZMD00
drop table #ZZMD01
drop table #ZZAM02

Best Practices ⟩

Authentication ⟩

Authorization ⟩

Encryption

Web Security ⟩

0 comments

Details

Knowledge Article

Published:

December 31, 2020

Last Updated:

December 31, 2020