[RESOLVED] How to use the LEFT function against a cube member

[gagnonp]

I want to use the left function in a dimensional report studio query.

For example:  left([great_outdoors_sales_en].[Currency].[Currency].[Member Description], 2)

Returns: RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'.

I tried to use left function in conjuction with the caption function, the rolevalue function. No luck...

[MFGF]

Hi,

In what context are you trying to use the result?  Is there any more to the error returned? Generally the message you posted is followed by a more detailed error? What are you trying to do in your report?

MF.

[gagnonp]

Beep Beep!

Here's the context: Return the 2 first characters of a cube member into a data item:

1. Open report studio with great_outdoors_sales_en package (cube)
2. Create a new list report
3. open query1 in query explorer
4. from the toolbox, drag a data item and paste: left([great_outdoors_sales_en].[Currency].[Currency].[Member Description], 2)
5. Click run, view tabular data.

[MFGF]

substring([great_outdoors_sales_en].[Currency].[Currency].[Member Description],1,2)

Works fine for me...

[gagnonp]

Thank you so much for your time.

I realize now that SUBSTRING function is under Common Functions, LEFT is under Vendor specific.  When using a cube as a data source, the vendor specific functions are not working.

Case closed!