ITAS01
asked on
dynamic naming a dimension in SSAS 2008
I am designing a cube for a database that allows custom captions for various field / tables. I was wondering if it is possible to have the name of the dimension dynamically assigned based on a query?
For example a DIMENSION is called CUSTOM1 but there is a caption table that has the user assigned name to this. Therefore would actually like this DIMENSION to have the caption name.
Using SQL 2008 OLAP.
Any other ideas?
Cheers
Damien
For example a DIMENSION is called CUSTOM1 but there is a caption table that has the user assigned name to this. Therefore would actually like this DIMENSION to have the caption name.
Using SQL 2008 OLAP.
Any other ideas?
Cheers
Damien
ASKER
Rob,
Launceston. Which company you work for?
Can you give me an example? Would I put the string variable in the Dimension name properties field?
Cheers
Damien
Launceston. Which company you work for?
Can you give me an example? Would I put the string variable in the Dimension name properties field?
Cheers
Damien
I work for LobsterPot Solutions.
So, suppose you're using Reporting Services, and the user has provided "Customer" as the dimension name (in the parameter @DimensionName), and you're wanting the list of Cities, you might want to do something like:
StrToSet(@DimensionName + ".City.City.Members")
So, suppose you're using Reporting Services, and the user has provided "Customer" as the dimension name (in the parameter @DimensionName), and you're wanting the list of Cities, you might want to do something like:
StrToSet(@DimensionName + ".City.City.Members")
ASKER
Rob,
I was more thinking at the cube level rather than through a client. I have a 3rd party .NET tool that I could encompass this with but thinking that at the cube level having the dimension name dynamically populated from an entry in another table in DSV. Example the database has a dimension called CUSTOM1 now this the name of the table / dimension but there is another caption table that has aliases for all these custom fields e.g. CUSTOM1 = CLIENT and every customer has different names for the CUSTOM1-30 fields which correllate to dimensions.
Does that make sense?
Also I have been dabbling in BI for a few years but always keen to have access to specialists in this field. Do you provide 1 on 1 consulting training e.g over web sometimes I don't mind paying for someone who knows what they are doing to help me solve real world problems.
And your based in OZ!
Cheers
Damien
I was more thinking at the cube level rather than through a client. I have a 3rd party .NET tool that I could encompass this with but thinking that at the cube level having the dimension name dynamically populated from an entry in another table in DSV. Example the database has a dimension called CUSTOM1 now this the name of the table / dimension but there is another caption table that has aliases for all these custom fields e.g. CUSTOM1 = CLIENT and every customer has different names for the CUSTOM1-30 fields which correllate to dimensions.
Does that make sense?
Also I have been dabbling in BI for a few years but always keen to have access to specialists in this field. Do you provide 1 on 1 consulting training e.g over web sometimes I don't mind paying for someone who knows what they are doing to help me solve real world problems.
And your based in OZ!
Cheers
Damien
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Performance may be ordinary, but it should work just fine.
What part of Tassie? (I'm in Adelaide)