create local/global cube with parent child dimension -
06-07-2004
, 02:56 AM
Hello
I will create local cube files with a parent child dimension.
CREATE global CUBE [Budget]
STORAGE 'c:\Budget.cub' FROM [Budget]
(MEASURE [Budget].[Amount], DIMENSION [Budget].[Account],
DIMENSION [Budget].[Category], DIMENSION [Budget].[Store],
DIMENSION [Budget].[Time]
When I make as Select on the cube File
select
Account.members on columns,
category.members on row
from budge
I can see, that there are not all values available. Many values show
the value #ERR (Doubleclick on #Err shows the message
"Unable do display cell Properties. Cube Salse is not available..."
But the cube Sales is never referenced by the cube Budge
What's wrong? Is it a problem with the parent child dimensio
Account
Advice plesase
Thanks in advance
Michael |