dbTalk Databases Forums  

ProcessAdd on Dimension II

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


Discuss ProcessAdd on Dimension II in the microsoft.public.sqlserver.olap forum.



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

Default ProcessAdd on Dimension II - 05-11-2006 , 08:20 AM






Hello
I want to do ProcessAdd on a dimension. I use the technique described here
in the thread ProcessAdd on Dimension.
In DataSourceView I have a named query from which I read the dimension data.
For process I use XMLA. In the <Process> tag are tags <DataSource> and
<DataSourceView> which have same ids and names as in Analysis database.
<DataSourceView> tag contains only a definition of named query, which
msprop:QueryDefinition is with WHERE clausule.

The Process runs without error, but if I look to trace, I see that the query
which reads the dimension does not contain the WHERE clausule. It seems that
"out of line bindings" are not applied.

What can be wrong?

Ondrej Srubar

Reply With Quote
Reply




Thread Tools
Display Modes

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.