Hi!

When I do this simple sample Analysis Service return me that error:
"Column expression associated with level '_TemplateLevel' is not found."
What is wrong?

What is <Template>? Any sample? (But not LevelNamingTemplate Dialog Box,
sample code is needing)

Who can send me sample code with dimension parent-child? Thanks for your
help.

CREATECUBE=CREATE CUBE Sample(
DIMENSION [Products] DIMENSION_STRUCTURE PARENT_CHILD,
LEVEL [All products] TYPE ALL ,
LEVEL [Level] ROOT_MEMBER_IF
ROOT_IF_PARENT_IS_BLANK_OR_SELF_OR_MISSING ,
MEASURE [Price]
Function Sum
Format '#.#'
)

INSERTINTO = INSERT INTO Sample(
Products.[Level].NAME,
Products.[Level].KEY,
Products.[Level].PARENT,
Measures.[Price]
)
SELECT
SampleTable.name,
SampleTable.my_id,
SampleTable.parent_id,
SampleTable.price
FROM
SampleTable