Hi,
I am trying to create a SUBCUBE in Microsoft Visual Studio (Analysis Services) but
It keeps on giving me an error when trying to build the Subcube.
The MDX statement is correct because I have tested it in SQL2005 Management Studio and it works.
My question is that “am I doing it in the right place?”:
This is under the Cubes Folder > Calculations Tab> New Script Command
My understanding is that under the “New Script Command” I can type any MDX statement and it should work? Or should this be done in another place?
When processing the cube the error I am getting back is:
Parser: The script contains the statement, which is not allowed
What I am trying to do is to create a slice of a cube by e.g. Brand which one of my departments need to use and should not see the other Brands. All the other dimensions and measures should still apply.
I would appreciate it if someone can please assist me with this.
Thank you in advance
Pieter Nelson
im no expert in olap cubes and am only tinkering with them for the last few months, but ive never heard of sub cubes. in that suituation, id either use a front end to create a report that filters out all but the brand your interested in, or create a seperate cube, based on the exact same data source view, but just import the brand you require. there may be a more elegant way, but those ways are pretty simple.
Regards,
Winston.
|||Hi Pieter,
It sounds like you need to be using dimension security, not subcubes here. See
http://msdn2.microsoft.com/en-us/library/ms175366.aspx
for details on how to do this.
HTH,
Chris
|||Unfortuanately I can not use Security or Another Measure Group.
I went into the Calculations Tab in Visual Studio and edited the Calculate Script that look like this:
-
CALCULATE;
CREATE SUBCUBE [Cube_AcqMgmtGF_Mthly] AS SELECT
{[All Brands].[All Brands].[Brand].&[Goldfishka B]} ON 0
FROM [Cube_AcqMgmtGF_Mthly];
CREATE MEMBER CURRENTCUBE.[MEASURES].[Ave first Purchase]
AS '[Measures].[First Purch]/[Measures].[Usaccountno]',
FORMAT_STRING = "Currency",
VISIBLE = 1;
-
I am still trying to filter this cube to one specific brand, but the deployment keeps on failing with the following Description:
"An MDX Statement was expected. An MDX expression was specified" "The script contains the statement, which is not allowed"
To be honest here, I am now getting really confused.
SUMMARY:
Is my code in the right place "Create Subcube" or is there an alternative way of doing this.
PLEASE HELP ANYONE?
|||
Hi Pieter,
To be honest, I can't see anything wrong with your MDX (which service pack are you runnning?) but even if you could create a subcube in your MDX Script I don't think it's going to do what you want - even though I'm able to deploy a CREATE SUBCUBE command in an MDX Script it doesn't look like it does anything useful.
Why can't you use security or another measure group? Can you explain what you want to do in more detail?
Chris
|||Hi,
I am trying to create subcubes(by Brands) from a Master cube (by only processing one cube), but the situation is that if I create a cube for every brand then it will be different processing for every cube. Unfortuanately these fact tables contains millions of records and processing all these records for every cube will take much longer. The other problem is that if there is changes in the logic of one fact table then I will have to apply these changes to all the other cubes individually.
Hope this helps?
|||This sounds exactly what dimension security is intended for. Why do you say you can't use it?
Chris
