Hi all,
in the above pic....
COGS,QTY,TURNOVER i need these to be put inside a new measure folder, and i need to change the measure names to
Help me out in doing this
Thanks
Technology Tips and News
Hi all,
in the above pic....
COGS,QTY,TURNOVER i need these to be put inside a new measure folder, and i need to change the measure names to
Help me out in doing this
Thanks
Hi Ranjan DS,
You need to open your Analysis Services Project (off-line mode) or directly your Analysis Services Database (on-line mode) using Business Intelligence Development Studio (if SQL 2005/2008/2008R2) or SQL Server Data Tools (if SQL 2012, 2014), open the cube holding the measures you want to change, using the measures pane at the top left hand side, select the and change the Display Folder for your measures using the Properties Windows for each of those measures:
For example I have a _Numerator measure that you can put in a KPIs folder:
In the same Properties Window, you can also rename the measures using the Name property, or if you are in the Measure window, right click over the measure, select Rename, and change the name.
Hi all,
I need to move the measures COGS, QTY,TURNOVER from sales measure to sales and order totals. Parallely i need the change the names of COGS, QTY,TURNOVER.
How to resolve this, do guide me.. or send me links where i can understand step by step.
Thanks
Ranjan DS
Hi Ranjan DS,
In Analysis Services, those folders you can see the Browser are Measure Group. We can only move up/down the measures within a Measure Group. So if you want to move those three measures to another "folder", you have the recreate them under another Measure Group. Please go to BIDS/SSDT, under Cube Structure, you can edit the Measure Group.
To change the name of measure, you just need to right on the measure and select "rename".
Re
Hi R,
You should
You should be good with that,
Hi Lees,
can you explain little in brief.
should i do any changes in SSIS file or SSMS??
tHANKS