chnage date item to member

[karthik12345]

Hi,

  how can i change value type data item to member?

Thanks,
Karthee

[Lynn]

Can you explain what you are trying to achieve? There are many posts about using the current date to construct a MUN. Is that what you mean? There is a member function that lets you define a member based on a value. Is that what you mean?

If you explain what you mean by "value type data item" and what you plan to do with the resulting member that you define you might get more information.

Does this post have anything to do with the post you created earlier? If so it would make more sense to keep a single thread going and provide the total picture to those who might be able to assist.

member ( value_expression [ , string1 [ , string2 [ , hierarchy ] ] ] )
Defines a member based on "value_expression" in "hierarchy". "String1" identifies the member created by this function. It must be unique in the query and different from any other member in the same hierarchy. "String2" is the caption of the member; if it is absent, the caption is empty. To ensure predictable results, it is recommended that you supply the "hierarchy".
Note: All calculations used as grouping items whose sibling items are other calculations or member sets should be explicitly assigned to a hierarchy using this function. The results are not predictable otherwise. The only exception is where the calculation involves only members of the same hierarchy as the siblings. In this case, the calculation is assumed to belong to that hierarchy.


Example: member ( total ( currentMeasure within set filter ( [great_outdoors_company].[Products].[Products].[Product name] , caption ( [great_outdoors_company].[Products].[Products].[Product name] ) starts with 'B' ) ) , 'BProducts' , 'B Products' , [great_outdoors_company].[Products].[Products] )
Result: Returns the quantity sold and revenue for all products that start with the letter B.

[karthik12345]

Thanks Lynn,
  sorry,From now i will keep in single thread.

  i wrote a tuple function as mentioned below
  tuple ([USD],[ Assets],[US],[Leg1],[Part],[Proj],[Taxes)],[Actuals],[Cust],[AE],[ RO],[TA], [Data item1])).

  in dataitem1=tail(children ([2016_Report]),1)( 2016_report having all months i.e jan 2016,feb 2016...)

but i am getting below error:
  XQE-PLN-0264
  The argument at position 13 of the function 'tuple' is invalid in data item 'Data Item2' of query 'Query1', expected one of the following types: 'member, measure'.

how can i solve the above issue.

Thanks in advance,
  Karthee

 

[Lynn]

The tail function returns a set, so you cannot use it in a tuple function. What are you trying to do with the tuple function? If you want to get a value of some measure at the intersection of various hierarchies then perhaps you want the aggregate function and specify "within set" details?

Not knowing your hierarchies makes giving any more specific advice difficult. At least for me :) Maybe others will chime in with further information that might help.