dbTalk Databases Forums  

Problems with build 9.00.2153

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.olap Problems with build 9.00.2153

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Problems with build 9.00.2153 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
chk
 
Posts: n/a

Default Problems with build 9.00.2153 - 09-22-2006 , 06:37 AM





The following calculated member works on 9.00.2047 but does not on
9.00.2153, does anybody know why ?

Avg(
Descendants(

[dimTime].[Fiscal Year - Month].CurrentMember,

[dimTime].[Fiscal Year - Month].[Month]

)

,

[Measures].[Head Count]

)



Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: Problems with build 9.00.2153 - 09-22-2006 , 10:26 AM





any error?
wrong result?
no result?


"chk" <noinfo@spam> wrote

Quote:
The following calculated member works on 9.00.2047 but does not on
9.00.2153, does anybody know why ?

Avg(
Descendants(

[dimTime].[Fiscal Year - Month].CurrentMember,

[dimTime].[Fiscal Year - Month].[Month]

)

,

[Measures].[Head Count]

)



Reply With Quote
  #3  
Old   
chk
 
Posts: n/a

Default Re: Problems with build 9.00.2153 - 09-23-2006 , 03:47 AM


The query cound not be processed: Internal Error: Unexpected Exception

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag
news:uSrRxtl3GHA.4560 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
Quote:
any error?
wrong result?
no result?


"chk" <noinfo@spam> wrote in message
news:uCwHBuj3GHA.2228 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
The following calculated member works on 9.00.2047 but does not on
9.00.2153, does anybody know why ?

Avg(
Descendants(

[dimTime].[Fiscal Year - Month].CurrentMember,

[dimTime].[Fiscal Year - Month].[Month]

)

,

[Measures].[Head Count]

)



Reply With Quote
  #4  
Old   
chk
 
Posts: n/a

Default Re: Problems with build 9.00.2153 - 09-25-2006 , 05:20 AM



SQL-Profiler Trace:

Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal Year -
Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS FROM
[SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:25:55.000 2006-09-23
11:25:55.000 SOMECORP_DWH 408194 EU <PropertyList
xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:25:55.000 2006-09-23 11:25:55.000 0 SOMECORP_DWH
408194 10
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:25:55.000 2006-09-23 11:25:55.000 0 SOMECORP_DWH
408194 10
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal Year -
Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS FROM
[SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:25:55.000 2006-09-23
11:25:55.000 0 SOMECORP_DWH 1 408194 10 EU
Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal Year -
Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS , NON
EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME
ON ROWS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:26:04.000
2006-09-23 11:26:04.000 SOMECORP_DWH 408194 EU <PropertyList
xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000010000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000010000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal Year -
Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS , NON
EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME
ON ROWS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:26:04.000
2006-09-23 11:26:04.000 10 SOMECORP_DWH 1 408194 0 EU
Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal Year -
Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS , NON
EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME
ON ROWS FROM [SOMECORP Cube] WHERE ([Measures].[Heads]) 814 SOMEUSER
2006-09-23 11:26:15.000 2006-09-23 11:26:15.000 SOMECORP_DWH 408194 EU
<PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal Year -
Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS , NON
EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME
ON ROWS FROM [SOMECORP Cube] WHERE ([Measures].[Heads]) 814 SOMEUSER
2006-09-23 11:26:15.000 2006-09-23 11:26:16.000 650
OMECORP_DWH -1056964586 408194 0 EU


Error Interner Fehler: Unerwartete Ausnahme. 814 SOMEUSER 2006-09-23
11:26:15.000 2006-09-23 11:26:16.000 SOMECORP_DWH -1056964586 408194 EU


Translation: Internal Error, Unexcepted Exception

"chk" <noinfo@spam> schrieb im Newsbeitrag
news:O4dX4zu3GHA.2228 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
Quote:
The query cound not be processed: Internal Error: Unexpected Exception

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag
news:uSrRxtl3GHA.4560 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
any error?
wrong result?
no result?


"chk" <noinfo@spam> wrote in message
news:uCwHBuj3GHA.2228 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
The following calculated member works on 9.00.2047 but does not on
9.00.2153, does anybody know why ?

Avg(
Descendants(

[dimTime].[Fiscal Year - Month].CurrentMember,

[dimTime].[Fiscal Year - Month].[Month]

)

,

[Measures].[Head Count]

)



Reply With Quote
  #5  
Old   
Akshai Mirchandani [MS]
 
Posts: n/a

Default Re: Problems with build 9.00.2153 - 09-25-2006 , 02:11 PM


Is this by any chance on IA64 platform?

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"chk" <noinfo@spam> wrote

Quote:
SQL-Profiler Trace:

Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal Year -
Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS FROM
[SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:25:55.000 2006-09-23
11:25:55.000 SOMECORP_DWH 408194 EU <PropertyList
xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:25:55.000 2006-09-23 11:25:55.000 0 SOMECORP_DWH
408194 10
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:25:55.000 2006-09-23 11:25:55.000 0 SOMECORP_DWH
408194 10
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal Year -
Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS FROM
[SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:25:55.000 2006-09-23
11:25:55.000 0 SOMECORP_DWH 1 408194 10 EU
Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal Year -
Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS , NON
EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23
11:26:04.000 2006-09-23 11:26:04.000 SOMECORP_DWH 408194 EU
PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000010000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000010000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal Year -
Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS , NON
EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23
11:26:04.000 2006-09-23 11:26:04.000 10 SOMECORP_DWH 1 408194 0 EU
Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal Year -
Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS , NON
EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] WHERE
([Measures].[Heads]) 814 SOMEUSER 2006-09-23 11:26:15.000 2006-09-23
11:26:15.000 SOMECORP_DWH 408194 EU <PropertyList
xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal Year -
Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS , NON
EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] WHERE
([Measures].[Heads]) 814 SOMEUSER 2006-09-23 11:26:15.000 2006-09-23
11:26:16.000 650 OMECORP_DWH -1056964586 408194 0 EU


Error Interner Fehler: Unerwartete Ausnahme. 814 SOMEUSER 2006-09-23
11:26:15.000 2006-09-23 11:26:16.000 SOMECORP_DWH -1056964586 408194
EU


Translation: Internal Error, Unexcepted Exception

"chk" <noinfo@spam> schrieb im Newsbeitrag
news:O4dX4zu3GHA.2228 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
The query cound not be processed: Internal Error: Unexpected Exception

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag
news:uSrRxtl3GHA.4560 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
any error?
wrong result?
no result?


"chk" <noinfo@spam> wrote in message
news:uCwHBuj3GHA.2228 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
The following calculated member works on 9.00.2047 but does not on
9.00.2153, does anybody know why ?

Avg(
Descendants(

[dimTime].[Fiscal Year - Month].CurrentMember,

[dimTime].[Fiscal Year - Month].[Month]

)

,

[Measures].[Head Count]

)



Reply With Quote
  #6  
Old   
chk
 
Posts: n/a

Default Re: Problems with build 9.00.2153 - 09-25-2006 , 04:45 PM


Yes

"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> schrieb im
Newsbeitrag news:etlu5ZN4GHA.1268 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Quote:
Is this by any chance on IA64 platform?

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for
newsgroup
purposes only.

"chk" <noinfo@spam> wrote in message
news:esf54wI4GHA.4976 (AT) TK2MSFTNGP02 (DOT) phx.gbl...

SQL-Profiler Trace:

Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:25:55.000
2006-09-23 11:25:55.000 SOMECORP_DWH 408194 EU <PropertyList
xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:25:55.000 2006-09-23 11:25:55.000 0 SOMECORP_DWH
408194 10
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:25:55.000 2006-09-23 11:25:55.000 0 SOMECORP_DWH
408194 10
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:25:55.000
2006-09-23 11:25:55.000 0 SOMECORP_DWH 1 408194 10 EU
Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] 814 SOMEUSER
2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 SOMECORP_DWH 408194
EU <PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000010000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000010000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] 814 SOMEUSER
2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 10 SOMECORP_DWH 1
408194 0 EU
Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] WHERE
([Measures].[Heads]) 814 SOMEUSER 2006-09-23 11:26:15.000 2006-09-23
11:26:15.000 SOMECORP_DWH 408194 EU <PropertyList
xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] WHERE
([Measures].[Heads]) 814 SOMEUSER 2006-09-23 11:26:15.000 2006-09-23
11:26:16.000 650 OMECORP_DWH -1056964586 408194 0 EU


Error Interner Fehler: Unerwartete Ausnahme. 814 SOMEUSER 2006-09-23
11:26:15.000 2006-09-23 11:26:16.000 SOMECORP_DWH -1056964586 408194
EU


Translation: Internal Error, Unexcepted Exception

"chk" <noinfo@spam> schrieb im Newsbeitrag
news:O4dX4zu3GHA.2228 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
The query cound not be processed: Internal Error: Unexpected Exception

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag
news:uSrRxtl3GHA.4560 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
any error?
wrong result?
no result?


"chk" <noinfo@spam> wrote in message
news:uCwHBuj3GHA.2228 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
The following calculated member works on 9.00.2047 but does not on
9.00.2153, does anybody know why ?

Avg(
Descendants(

[dimTime].[Fiscal Year - Month].CurrentMember,

[dimTime].[Fiscal Year - Month].[Month]

)

,

[Measures].[Head Count]

)



Reply With Quote
  #7  
Old   
chk
 
Posts: n/a

Default Re: Problems with build 9.00.2153 - 09-25-2006 , 04:49 PM


Yes, as far as I know this is an Itanium with 64GByte of RAM.
Is this a known bug, any KB references ?



"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> schrieb im
Newsbeitrag news:etlu5ZN4GHA.1268 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Quote:
Is this by any chance on IA64 platform?

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for
newsgroup
purposes only.

"chk" <noinfo@spam> wrote in message
news:esf54wI4GHA.4976 (AT) TK2MSFTNGP02 (DOT) phx.gbl...

SQL-Profiler Trace:

Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:25:55.000
2006-09-23 11:25:55.000 SOMECORP_DWH 408194 EU <PropertyList
xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:25:55.000 2006-09-23 11:25:55.000 0 SOMECORP_DWH
408194 10
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:25:55.000 2006-09-23 11:25:55.000 0 SOMECORP_DWH
408194 10
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:25:55.000
2006-09-23 11:25:55.000 0 SOMECORP_DWH 1 408194 10 EU
Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] 814 SOMEUSER
2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 SOMECORP_DWH 408194
EU <PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000010000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000010000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] 814 SOMEUSER
2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 10 SOMECORP_DWH 1
408194 0 EU
Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] WHERE
([Measures].[Heads]) 814 SOMEUSER 2006-09-23 11:26:15.000 2006-09-23
11:26:15.000 SOMECORP_DWH 408194 EU <PropertyList
xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] WHERE
([Measures].[Heads]) 814 SOMEUSER 2006-09-23 11:26:15.000 2006-09-23
11:26:16.000 650 OMECORP_DWH -1056964586 408194 0 EU


Error Interner Fehler: Unerwartete Ausnahme. 814 SOMEUSER 2006-09-23
11:26:15.000 2006-09-23 11:26:16.000 SOMECORP_DWH -1056964586 408194
EU


Translation: Internal Error, Unexcepted Exception

"chk" <noinfo@spam> schrieb im Newsbeitrag
news:O4dX4zu3GHA.2228 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
The query cound not be processed: Internal Error: Unexpected Exception

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag
news:uSrRxtl3GHA.4560 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
any error?
wrong result?
no result?


"chk" <noinfo@spam> wrote in message
news:uCwHBuj3GHA.2228 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
The following calculated member works on 9.00.2047 but does not on
9.00.2153, does anybody know why ?

Avg(
Descendants(

[dimTime].[Fiscal Year - Month].CurrentMember,

[dimTime].[Fiscal Year - Month].[Month]

)

,

[Measures].[Head Count]

)



Reply With Quote
  #8  
Old   
Akshai Mirchandani [MS]
 
Posts: n/a

Default Re: Problems with build 9.00.2153 - 09-26-2006 , 08:50 PM


Probably yes. You can contact support and ask for KB 923304.



http://support.microsoft.com/?kbid=923304



Thanks,

Akshai


--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.


"chk" <noinfo@spam> wrote

Quote:
Yes, as far as I know this is an Itanium with 64GByte of RAM.
Is this a known bug, any KB references ?



"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> schrieb im
Newsbeitrag news:etlu5ZN4GHA.1268 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Is this by any chance on IA64 platform?

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no
rights
Please do not send email directly to this alias. This alias is for
newsgroup
purposes only.

"chk" <noinfo@spam> wrote in message
news:esf54wI4GHA.4976 (AT) TK2MSFTNGP02 (DOT) phx.gbl...

SQL-Profiler Trace:

Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:25:55.000
2006-09-23 11:25:55.000 SOMECORP_DWH 408194 EU <PropertyList
xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:25:55.000 2006-09-23 11:25:55.000 0 SOMECORP_DWH
408194 10
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:25:55.000 2006-09-23 11:25:55.000 0 SOMECORP_DWH
408194 10
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:25:55.000
2006-09-23 11:25:55.000 0 SOMECORP_DWH 1 408194 10 EU
Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23
11:26:04.000 2006-09-23 11:26:04.000 SOMECORP_DWH 408194 EU
PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000010000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000010000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23
11:26:04.000 2006-09-23 11:26:04.000 10 SOMECORP_DWH 1 408194 0 EU
Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] WHERE
([Measures].[Heads]) 814 SOMEUSER 2006-09-23 11:26:15.000 2006-09-23
11:26:15.000 SOMECORP_DWH 408194 EU <PropertyList
xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] WHERE
([Measures].[Heads]) 814 SOMEUSER 2006-09-23 11:26:15.000 2006-09-23
11:26:16.000 650 OMECORP_DWH -1056964586 408194 0 EU


Error Interner Fehler: Unerwartete Ausnahme. 814 SOMEUSER 2006-09-23
11:26:15.000 2006-09-23 11:26:16.000 SOMECORP_DWH -1056964586 408194
EU


Translation: Internal Error, Unexcepted Exception

"chk" <noinfo@spam> schrieb im Newsbeitrag
news:O4dX4zu3GHA.2228 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
The query cound not be processed: Internal Error: Unexpected Exception

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag
news:uSrRxtl3GHA.4560 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
any error?
wrong result?
no result?


"chk" <noinfo@spam> wrote in message
news:uCwHBuj3GHA.2228 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
The following calculated member works on 9.00.2047 but does not on
9.00.2153, does anybody know why ?

Avg(
Descendants(

[dimTime].[Fiscal Year - Month].CurrentMember,

[dimTime].[Fiscal Year - Month].[Month]

)

,

[Measures].[Head Count]

)



Reply With Quote
  #9  
Old   
chk
 
Posts: n/a

Default Re: Problems with build 9.00.2153 - 09-27-2006 , 02:02 AM


Thanks for the hint,

strange I had searched the KB and this one did not turn up.


"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> schrieb im
Newsbeitrag news:eNCQXdd4GHA.1252 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Quote:
Probably yes. You can contact support and ask for KB 923304.



http://support.microsoft.com/?kbid=923304



Thanks,

Akshai


--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for
newsgroup
purposes only.


"chk" <noinfo@spam> wrote in message
news:eaZhByO4GHA.4820 (AT) TK2MSFTNGP06 (DOT) phx.gbl...
Yes, as far as I know this is an Itanium with 64GByte of RAM.
Is this a known bug, any KB references ?



"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> schrieb im
Newsbeitrag news:etlu5ZN4GHA.1268 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
Is this by any chance on IA64 platform?

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no
rights
Please do not send email directly to this alias. This alias is for
newsgroup
purposes only.

"chk" <noinfo@spam> wrote in message
news:esf54wI4GHA.4976 (AT) TK2MSFTNGP02 (DOT) phx.gbl...

SQL-Profiler Trace:

Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:25:55.000
2006-09-23 11:25:55.000 SOMECORP_DWH 408194 EU <PropertyList
xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:25:55.000 2006-09-23 11:25:55.000 0 SOMECORP_DWH
408194 10
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:25:55.000 2006-09-23 11:25:55.000 0 SOMECORP_DWH
408194 10
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS FROM [SOMECORP Cube] 814 SOMEUSER 2006-09-23 11:25:55.000
2006-09-23 11:25:55.000 0 SOMECORP_DWH 1 408194 10 EU
Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] 814 SOMEUSER
2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 SOMECORP_DWH 408194
EU <PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000010000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000010000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000001000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query Subcube 1 - Cache data
00000000000000000000000000000000000000000000,00000 000000,0000000000000000000000000
814 2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 0 SOMECORP_DWH
408194 0
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] 814 SOMEUSER
2006-09-23 11:26:04.000 2006-09-23 11:26:04.000 10 SOMECORP_DWH 1
408194 0 EU
Query Begin 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] WHERE
([Measures].[Heads]) 814 SOMEUSER 2006-09-23 11:26:15.000 2006-09-23
11:26:15.000 SOMECORP_DWH 408194 EU <PropertyList
xmlns="urn:schemas-microsoft-com:xml-analysis"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>COM
Query End 0 - MDXQuery SELECT NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimTime].[Fiscal
Year - Month].[All]})})) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON
COLUMNS , NON EMPTY
HIERARCHIZE(AddCalculatedMembers({DrillDownLevel({ [dimCostCenterPlan].[Location
- Cluster - CostCenter].[All]})})) DIMENSION PROPERTIES
PARENT_UNIQUE_NAME ON ROWS FROM [SOMECORP Cube] WHERE
([Measures].[Heads]) 814 SOMEUSER 2006-09-23 11:26:15.000 2006-09-23
11:26:16.000 650 OMECORP_DWH -1056964586 408194 0 EU


Error Interner Fehler: Unerwartete Ausnahme. 814 SOMEUSER 2006-09-23
11:26:15.000 2006-09-23 11:26:16.000 SOMECORP_DWH -1056964586 408194
EU


Translation: Internal Error, Unexcepted Exception

"chk" <noinfo@spam> schrieb im Newsbeitrag
news:O4dX4zu3GHA.2228 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
The query cound not be processed: Internal Error: Unexpected Exception

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag
news:uSrRxtl3GHA.4560 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
any error?
wrong result?
no result?


"chk" <noinfo@spam> wrote in message
news:uCwHBuj3GHA.2228 (AT) TK2MSFTNGP03 (DOT) phx.gbl...
The following calculated member works on 9.00.2047 but does not on
9.00.2153, does anybody know why ?

Avg(
Descendants(

[dimTime].[Fiscal Year - Month].CurrentMember,

[dimTime].[Fiscal Year - Month].[Month]

)

,

[Measures].[Head Count]

)



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top