Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi -
I created a hierarchy which is loaded as part of my script.
When this hierachy is used as part of my selections, all values get filtered out. Any idea on why my hierachy hides all values in my pivot table?
Thank you!!!!!
CrossTable(Period, Data, 5)
LOAD [Row Labels] as [Test Description],
[Profit_Center],
[Currency],
[GL Account],
[Gl Account Description],
[Period 12 FY2009],
[Period 1 FY2010],
[Period 2 FY2010],
[Period 3 FY2010],
[Period 4 FY2010],
[Period 5 FY2010],
[Period 6 FY2010],
[Period 7 FY2010],
[Period 8 FY2010],
[Period 9 FY2010],
[Period 10 FY2010],
[Period 11 FY2010]
FROM
(ooxml, embedded labels, header is 1 lines, table is Sheet1, filters(
Replace(1, bottom, StrCnd(null)),
Replace(2, bottom, StrCnd(null)),
Replace(3, bottom, StrCnd(null)),
Replace(4, bottom, StrCnd(null)),
Replace(5, bottom, StrCnd(null))
));
Profit_Center:
LOAD * Inline [
All, Region, Profit_Center, Website_Country
All, Test1, A
All, Test1, B, C
All, Test1, B, C
All, Test1, B,C, D
];
Hierarchy_Table:
Load * ,
All &'-'&Region&'-'&Profit_Center&'-'&Website_Country as HierarchyPath
Resident Profit_Center;
Drop table Profit_Center;
Hi.
Your Hierarchy table connected with your data through Profit_Center field.
Create a Listbox with Profit_Center and check that the values 'A','B' exist in your Data table (the one you loaded first).
Hi - yes i checked and they do.
So, it should work.
They should exist in both tables.
Test only first load statmenet (temporarily comment the rest).
No it doesn't work. Any ideas?
Thank you
Actually you are right the A, B values do not exist. How can i make a connectiong between the two?
Thank you
Hi.
You have the connection. You don't have values.
I guess only you can answer the question why you use different values in you inline table for Profit_Center.