在表格模型ssas中创建类型并连接到维度 [英] Create type and connected to dimension in tabular model ssas

问题描述

嗨朋友们，

我在SSAS的表格模式下工作。创建一个多维数据集后，我需要连接目标系统excel。 

I am working in tabular mode of SSAS. After creating a cube i need to connect with excel which is target system. 

我成功地将多维数据集与excel连接并使用Cubevalue函数但现在我有一个业务需求来创建类型衡量而不是一次又一次地使用表名。 

I successfully connected cube with excel and also using Cubevalue function but now i got one business requirement to create type for measures and not to use table name again and again. 

必需的格式= cubevalue（" ODBC数据库";" [财务数据]";" [Measure]。 [MTD]英寸;"。[类型] [量]英寸;" [年] 0.2019]英寸;" [月] [Januari]英寸;" [帐户] [3011] "）。

Required format=cubevalue("ODBC databas";"[Financial data]";"[Measure].[MTD]";"[type].[amount]";"[year].2019]";"[Month].[Januari]";"[Account].[3011]").

我有三个不同的集成系统，每个系统有10个不同的视图。维度列名称几乎相同，唯一的区别在于度量名称。因此，他们希望为[type]创建一列，然后选择度量类型，然后只需列名
但不重复视图名称或可能是表名。

I have three different integration system each having 10 different views. Dimension column name are almost same only difference is in name of measure. So they want to make one column for [type] and then choose type of measure and then simply column names but not repeating views name or may be table names.

简单我们正在使用 

Simple we are using 

== CUBEVALUE（"。testdata Hastus Cube"" [Measures]。[Amount]";" [Actual YTD]。[År]。[ 2017]" [Actual YTD]。[period]。[Januari]" [] [Actual YTD]。[Account]。[All]。[3020]" [] [Actual YTD]。 [Ställe]。[All]。[349]"）/ 1000

==CUBEVALUE(". testdata Hastus Cube";"[Measures].[Amount]";"[Actual YTD].[År].[2017]";"[Actual YTD].[period].[Januari]";"[Actual YTD].[Account].[All].[3020]";"[Actual YTD].[Ställe].[All].[349]")/1000

此处"[Actual YTD]"正在重复很多时间，但他们不想重复。

here "[Actual YTD]" is repeating lots of time but they did not want to repeat.

如果有任何问题让我知道，请欣赏任何输入值。

Please any input value is appreciated and also if any question let me know.

提前致谢，

问候，

Shilpi

 

推荐答案

如果有人能帮助我真的很紧急。

Please if anyone can help me its really urgent.

这篇关于在表格模型ssas中创建类型并连接到维度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！