/content/folder[@name='Samples']/folder[@name='Models']/package[@name='GO Data Warehouse (query)']/model[@name='model']No Data AvailableNo Data Available:
No Data AvailableNo Data AvailableListNo Data Available[Sales (query)].[Retailers].[Region][Sales (query)].[Retailers].[Retailer country][Sales (query)].[Sales fact].[Quantity][Sales (query)].[Time].[Year][Sales (query)].[Retailers].[Region][Sales (query)].[Retailers].[Retailer country][Sales (query)].[Sales fact].[Quantity][Sales (query)].[Time].[Year][Sales (query)].[Employee by manager].[Level 3 manager][Sales (query)].[Products].[Product type][Sales (query)].[Promotions].[Campaign name]#prompt('Filter','token','1=1')#select distinct
Union1.Name as Name,
Union1.Filter2 as Filter2
from
(((((select
'An Li' as Name,
'[Sales (query)].[Promotions].[Campaign name] in (''Hibernator Campaign'', ''Course Pro Campaign'')' as Filter2
from
(values('all_level')) Query2(c1)
)
UNION
(select
'Aron Adelsvärd' as Name,
'[Sales (query)].[Promotions].[Campaign name] in (''Course Pro Campaign'', ''Seeker Campaign'')' as Filter2
from
(values('all_level')) Query3(c1)
)
)
UNION
(select
'Dietz Krieger' as Name,
'[Sales (query)].[Promotions].[Campaign name] in (''TrailChef Campaign'', ''Rising Star Campaign'')' as Filter2
from
(values('all_level')) Query4(c1)
)
)
UNION
(select
'Isabel Torres' as Name,
'[Sales (query)].[Promotions].[Campaign name] = ''Canyon Mule Campaign''' as Filter2
from
(values('all_level')) Query5(c1)
)
)
UNION
(select
'Maria Boscolo' as Name,
'[Sales (query)].[Promotions].[Campaign name] in (''Big Rock Campaign'', ''Outdoor Protection Campaign'')' as Filter2
from
(values('all_level')) Query6(c1)
)
)
Union1(Name,
Filter2)[SQL1].[Name][SQL1].[Filter2]select distinct
Union1.Column as Column
from
((select
'[Sales (query)].[Promotions].[Campaign name]' as Column
from
(values('all_level')) Query2(c1)
)
UNION
(select
'[Sales (query)].[Time].[Year]' as Column
from
(values('all_level')) Query3(c1)
)
)
Union1(Column)[SQL2].[Column]#prompt('Column','token','1')#Master Detail