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...
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.
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.
substring([great_outdoors_sales_en].[Currency].[Currency].[Member Description],1,2)
Works fine for me...
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!