Dynamic Labels in Visual Composer

[Former Member]

Hi ,

i am Working on Visual Composer 7.0 sp17 , Picking TheBi Queries To VC Work Space .

Here BI Developer Created Dynamic Variables in Table .

Let s Check ,

Here my input seelction is Fiscal Year 2009 .

Output of the table is :

OcT2009 | Nov2009 |Dec2009|Jan2010|Feb2010

This is the Out For This Month .

If We have Moved to Next Month

OcT2009 | Nov2009 |Dec2009|Jan2010|Feb2010|Feb 2010

This Labels And Data Dynamically Will Change in Table .

I Have Taken Dynamic port Option Checked and i did n't Taken Any Selection In Table Now Data Is coming Perfect .

My Issue is The Labels Which is coming from BI System are Not Good Format i mean it is coming

OCT_2009_MT | Nov_2009 _MT |....................etc.

I want These labels Should be Dynamically renamed with OCT2009 TE Value .

how can i set The Labels Dynamically .

Regards ,

venkat p

[Former Member]

hello for dynamic labelling you can try

1. adding a form

2. make is transparent

3. add expression box

4. add the code in expression box for related variable or filed from table

5. deploy

this will populate the value of that variable..creating dynamic labels

[Former Member]

Hi ,

My Issue is Here In BI They Have Created Dynamic Fileds From Back End

Let See

For This Month .

Input-> Fiscal Year : 2009

Output Table :

OCT 2009 TE | Nov2009|Dec2009|Jan2010|Feb2010.

Let See For Next Month on March1st .

Input-> FiscalYear :2009

Output Table :

OCT 2009 TE | Nov2009|Dec2009|Jan2010|Feb2010|Mar2010.

For Every month That particular Month Value Will When We Move Next Month .

I have Seen if i did not seleced Any Fileds in Table the Values And Labels are Changing Accordingly to BI Logic .

Here Customer Want the label Names Like Below.

OCT 2009 TE Value | Nov2009 Value |Dec2009 Value |Jan2010 Value |Feb2010 Value |Mar2010 Value .

But From BI To VC The Actual Labels Are coming Below format .

OCT _2009 TE | Nov2009_TE|Dec2009_TE|Jan_2010_TE|Feb_2010_TE|Mar_2010_TE.

This is Dynamic Labels Are coming from BI System

i want from where these labels are coming frm the BI System.

if i modify in BI System the labels then this will possible i think soo

or ANy Other Solution .

Regards ,

venkat p

[Former Member]

Hi Venkat

These are called as 'Text Variables' in BI. For that structure of Month & Year, there must be a text variable in BI. That text variable will look like what you have explained in this thread. If you want to change any thing then you have to change this 'Text Variable'

Path for that -

BI Query -> Structure of Month & Year -> Structure Element - > Properties -> General Tab -> DropDown Box (Near the structure Name)

Regards

Sandeep

[Former Member]

Hi ,

Can you please Elaborate Where i can get the Exact path in BI system To Set the Field Header Labels Dynamically From BI System .

Regards ,

venkat p

[Former Member]

Hi

You need to follow the process -

1. First you need to create 'Text Variable' (Query -> Structure Element Name -> Text Variable icon)

2. You need to go to BI T-code - 'CMOD'

3. There you need to write code for populating the 'Month or Year' dynamically.

4. You should create Structure for the month or Year as per your requirement in BI query

5. Then you have to use this Text Variable for all the Structure element. (You need to select it from 'Text Variable Icon')

6. After this your 'Structure element will look like - &Variable tech name&

7. Then you use this in VC model it will show month text dynamically.

If you have any doubt let me know. For more explanation on Text variable you can search in 'Business Information Warehouse' forum you may get code also over there.

Regards

Sandeep

[Former Member]

Hi ,

Here my labels are changing Dynamically n VC but the Label Text Is coming like OCT_2009 , But Alignment is also not proper in VC can you please help me in this regard i have not selected any fields in VC but the Field Headers are coming Dynamically from BI System But Not Good Format as we need OCT 2009 ( it is coming oct_2009 ) how to set these variable text & Alignment in BI or in VC .

Regards ,

venkat p