Viewing 15 posts - 1,456 through 1,470 (of 1,839 total)
Welcome to the world of un-named parameters. I have found to use parameters with MX you'll need to create a dynamic query string that gets executed. e.g. the query starts...
May 11, 2005 at 10:53 pm
WHile I agree with the theory I have never been able to get that to work (the other Datasources aren't displayed in the replace table dialog). The closest I have...
May 11, 2005 at 8:18 pm
Todd,
Can you make a new connection to the cube? ie is it visible in the cube list? If not, check that the visibility of the cube hasn't been set to...
May 10, 2005 at 8:13 pm
According to Phil this can be done (ie I've not done it) but what he says definitely make sense theoretically.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=162&messageid=174307&p=2
May 9, 2005 at 11:41 pm
Christian, just to confirm what wildh has said re: aggs and with reference to your question after my post, the aggregations don't change but the values that are being aggregated...
May 8, 2005 at 5:50 pm
He means the counts (member counts) against each of the levels within each dimension. These influence the aggregation wizard (along with the anticipated fact table size) when calculating aggregations.
I...
May 5, 2005 at 8:57 pm
If you wanted to test this theory, set your logging of user queries to 1 (instead of deault of every 10), run the query/s (check the log to ensure they...
May 5, 2005 at 5:42 pm
Definitely noticed this as a problem, PTS can clag things up extremely well. Some things to check are:
i) I know you said this but make sure that the client...
May 4, 2005 at 5:09 pm
correct if it's a statement, hard to answer if it's question ![]()
May 4, 2005 at 4:56 pm
Jennifer,
Getting back to your original problem, how weere you trying to set the visible columns? I ran up a test using one of our cubes tat has 25k+ members (@...
May 1, 2005 at 10:00 pm
WIth the dims not set to 'changing' , have you tried processing them (incrementally) as a seperate activity to processing the cube (ie right click on dim and then process...
April 29, 2005 at 1:31 am
I agree with your conclusion (1) re: it shouldn't make a difference being changing or non-chaning, as reading the doco re: dimension processing and in particular incrementals it refers to...
April 28, 2005 at 5:41 pm
I can't think of much, other than writing some VBA to either i) set the MDX query string, or ii) leave the string as is and set the (say) rows...
April 28, 2005 at 5:29 pm
The web components *should* be accessible past the intranet the only real issue is the security for using AS. Unless you're running Win2K3 at the server end OR you're running...
April 28, 2005 at 5:26 pm
re: granting access via a role, remember to set the 'Allow drillthrough' checkbox in the role too. ie On the AS side you need to allow drill through i) in...
April 28, 2005 at 5:14 pm
Viewing 15 posts - 1,456 through 1,470 (of 1,839 total)