Language Switching in Active analysis

Posted by: joby003 on 3 August 2017, 3:57 pm EST

  • Posted 3 August 2017, 3:57 pm EST

    I am using grapecity Schemabuilder in my application. I want to switch between different languages in my application.

    Is it possible to change the language of the captions (header) present in the Schemabuider (different languages including Arabic)?

    can I handle it within the code? if yes how?

  • Replied 3 August 2017, 3:57 pm EST

    Hello,

    In the above Schema the captions of the dimensions are not changed. You would need to manually change the "Caption" of each filed item to the localized string. Once you save this schema, point your application to use this schema file and you would notice the localized schema.
    If you still have questions, please feel free to ask.

    Regards,
    Aashish
  • Replied 3 August 2017, 3:57 pm EST

    Hi,



    Is the latest version of ActiveAnalysis able to change captions programmatically? having to change the schema file is not an option for me due to changing nature of data retrieved. Data source is relational.



    Thanks.
  • Replied 3 August 2017, 3:57 pm EST

    shinigami,

    If you already have a schema and looking to change the captions for the schema fields, then you cannot do it programmatically. With the latest build we have included a schema editor which can be used to make modifications to your schema including the caption. Please take a look at this link for more information.

    However if you are generating the schema using the SchemaBuilder class, you can set the caption for the attributes and measures by setting the Caption property.

    Regards,
    Sankalp
  • Replied 3 August 2017, 3:57 pm EST

    Hello,

    To localize schema, you need to Open the *.schema file in a text or XML editor.
    Than Scroll down to the dimensions and for each fields item in each type of dimension, change the caption value to a localized version of the string.
    When you have localized all of the dimension field captions, save the file with an encoding type of UTF-8 to preserve the character format of non-ANSI text.

    The detailed instructions and screenshots to localize the schema and Pivot View are described here.

    Regards,
    Aashish


  • Replied 3 August 2017, 3:57 pm EST

    Aashish,

    I have created the *.schema file but it does not contains all the captions which is present in the Schema.
    yet I have changed all the captions present in it and run it ,But it does not make sense in my application.

    I am attaching the *.schema file with this



       
           
           
           
           
           
       

       
           
                Attributes
               
                   
                        OrderID
                        Order ID
                        Attribute
                        =Fields!OrderID.Value
                        =Fields!OrderID.Value
                   

               

                Attributes
                [Attributes].[OrderID]
           

           
                Measures
               
                   
                        OrderID
                        Order ID
                        Measure
                        =Fields!OrderID.Value
                        Sum
                       
                       
                        #,##0.00;(#,##0.00)
                        0
                   

                   
                        ProductID
                        Product ID
                        Measure
                        =Fields!ProductID.Value
                        Sum
                       
                       
                        #,##0.00;(#,##0.00)
                        0
                   

                   
                        UnitPrice
                        Unit Price
                        Measure
                        =Fields!UnitPrice.Value
                        Sum
                       
                       
                        #,##0.00;(#,##0.00)
                        0
                   

                   
                        Quantity
                        Measure
                        =Fields!Quantity.Value
                        Sum
                       
                       
                        #,##0.00;(#,##0.00)
                        0
                   

                   
                        Discount
                        Measure
                        =Fields!Discount.Value
                        Sum
                       
                       
                        #,##0.00;(#,##0.00)
                        0
                   

               

                Measures
           

       

       
            [Measure Names]
            [Measure Values]
       



    Regards,
    Joby
  • Replied 3 August 2017, 3:57 pm EST

    Thanks for the quick response Mr. Sankalp.



    I've been looking at the ways to set the schema source for the RDDataSource of the PivotView. Based from your reply, is it correct for me to say that it can only load a schema file and not a programmatically-generated schema? It seems one still has to save the latter before it can be loaded into the RDDataSource.
  • Replied 3 August 2017, 3:57 pm EST

    shinigami,

    Yes you are correct. You will need to save the schema file which you created. This is because you must specify the CustomSchemaFile property value before you can connect to a RD Datasource since schema file describes a cube structure and contains
    definitions of objects such as query fields, dimensions and measures.

    Regards,
    Sankalp
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels