Create a Dimension in a cube based in a condition

This is a discussion on Create a Dimension in a cube based in a condition within the Microsoft SQL Server forums in category; Hi, I'm new in the forum and a dummy in Analisys Server. I have created a CUBE and I would like to create a Dimension non based on the table, instead depending of the value of onw field return a value P.e IIF(cps='A', 'Hello', 'Bye') What code I need to add to the cube or how I can create the dimensbsion?...

Go Back   Database Forum > Microsoft SQL Server

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 05-12-2008, 03:23 PM
Default Create a Dimension in a cube based in a condition

Hi, I'm new in the forum and a dummy in Analisys Server.
I have created a CUBE and I would like to create a Dimension non based on the table, instead depending of the value of onw field return a value

P.e IIF(cps='A', 'Hello', 'Bye')

What code I need to add to the cube or how I can create the dimensbsion?
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 04:40 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.