Не уверен, что это сработает, но попробуйте и это:
Здесь заменен пункт WITH
на subselect
with member [Measures].[Calculation] as
Format(
IIF(isempty([Measures].[average complience to requirements]), null,
[Measures].[average complience to requirements]),
"#,0.00"
)
select
non empty
{
[Measures].[average complience to requirements],
[Measures].[Calculation]
} on 0,
nonempty
(
[Customer].[App Key Company Id].children *
[Location].[App Key Region Id].children *
[Category].[App Key Category Id].children *
[Vendor].[App Key Vendor Id].children
//[average complience to requirements] //removed
) on 1
from
(
SELECT
{
strtomember(
"[Date Submitted Date].[YYYY-MMMM-DD].[Month Of Year].&[" + Format( Now(), "yyyyMM") + "]"
):
strtomember(
"[Date Submitted Date].[YYYY-MMMM-DD].[Month Of Year].&[" + Format( Now(), "yyyyMM") + "]").Lag(2)
} ON 0
FROM [BSC]
)
Сколько времени занимают приведенные ниже запросы?
1) Нет вычисляемого элемента
//with member [Measures].[Calculation] as
// Format(
// IIF(isempty([Measures].[average complience to requirements]), null,
// [Measures].[average complience to requirements]),
// "#,0.00"
//)
select
non empty
{
// [Measures].[average complience to requirements], /////This measure removed
[Measures].[Calculation]
} on 0,
nonempty
(
[Customer].[App Key Company Id].children *
[Location].[App Key Region Id].children *
[Category].[App Key Category Id].children *
[Vendor].[App Key Vendor Id].children
//[average complience to requirements] //removed
) on 1
FROM [BSC]
where (
{
strtomember(
"[Date Submitted Date].[YYYY-MMMM-DD].[Month Of Year].&[" + Format( Now(), "yyyyMM") + "]"
):
strtomember(
"[Date Submitted Date].[YYYY-MMMM-DD].[Month Of Year].&[" + Format( Now(), "yyyyMM") + "]").Lag(2)
}
)
2) Ничего в ROWS
with member [Measures].[Calculation] as
Format(
IIF(isempty([Measures].[average complience to requirements]), null,
[Measures].[average complience to requirements]),
"#,0.00"
)
select
non empty
{
[Measures].[average complience to requirements], /////This measure removed
[Measures].[Calculation]
} on 0,
{} on 1
FROM [BSC]
where (
{
strtomember(
"[Date Submitted Date].[YYYY-MMMM-DD].[Month Of Year].&[" + Format( Now(), "yyyyMM") + "]"
):
strtomember(
"[Date Submitted Date].[YYYY-MMMM-DD].[Month Of Year].&[" + Format( Now(), "yyyyMM") + "]").Lag(2)
}
)
3) НЕТ СЛИСЕРА
select
non empty
{
// [Measures].[average complience to requirements], /////This measure removed
[Measures].[Calculation]
} on 0,
nonempty
(
[Customer].[App Key Company Id].children *
[Location].[App Key Region Id].children *
[Category].[App Key Category Id].children *
[Vendor].[App Key Vendor Id].children
//[average complience to requirements] //removed
) on 1
FROM [BSC]
Если из них ничего не получается, просто выполните еще одно аналогичное устранение неполадок, чтобы определить фактическую причину проблемы. Как только вы разберетесь, будет легко работать над этим. Для нас, очевидно, бессмысленно проводить анализ в кресле, не имея представления о внутреннем кубе, когда фактический запрос выглядит вполне нормально.
person
SouravA
schedule
09.01.2015
[average complience to requirements]
в обеих осях? Удалите его изAXIS(1)
- person SouravA   schedule 09.01.2015