Yes.
Eg:-select {[Fiscal_ Dimension].[FY 2011]} on columns from [Cube_name] where (Parameter(“Product_Name”, MEMBER,[PRODUCT_ Dimension]))
When the above query run, Query pause during preview whenever a Parameter(...) statement is encountered in the query definition. A dialog box opens, prompting you to enter a value for the parameter. Enter a value and click OK. According the value it is filtering the value at runtime.
Can essbase mdx functions be used in mdx for iop?
ReplyDeleteWhen we use the following command, it is only grabbing one from each level. It seem Descendants function isnt working.
SELECT
{
[Measures].[Forecast Unit Cost]
}
ON COLUMNS,
{
CROSSJOIN({Descendants([PLANT_MFG_BOM].[MI04])},{SystemPeriod([FISCAL].[Period])})
}
ON ROWS
FROM [FORECAST]
QUERY PROPERTIES flattenColumns="true"
Any help would be appreciated.
Best Regards,
Scott
http://hyperionapplications.blogspot.com/