Current Position:Home > Using environment variable in rule file

Using environment variable in rule file

Update:10-11Source: network consolidation
Advertisement
Hi,
I want to datacopy from one cube (scenario Forecast) to another (scenario FcstJan, FcstFeb, and so on) based on which month is running currently. I want to use environment variable in the rule file. The Forecast data will be extracted in .txt and will be imported to the second cube in FcstJan if current month is Jan and same for Feb, Mar..... The CurrentMth will be my env variable.
Can anyone please let me know how I can use that variable in the rule file. Or, if there is any other way to load the same.
Thanks.

The Best Answer

Advertisement
You could just set a substitution variable and then use the substitution variable in the header of the rule.
Have a read of :- Re: Data error
to understand about using substitution variables in the header of a rule file.
Cheers
John
http://john-goodwin.blogspot.com/
  • Using environment variable in rule file Update:10-11

    Hi, I want to datacopy from one cube (scenario Forecast) to another (scenario FcstJan, FcstFeb, and so on) based on which month is running currently. I want to use environment variable in the rule file. The Forecast data will be extracted in .txt and

  • Susbtitution Variables in rules file to replace a member name with another Update:10-11

    Hi everybody, Can I use substitution variables to replace a member name with another name in rules file? Please let me know if we can use substitution vars. Essbase version :11.1.2 Thanks, K.asAre you the same guy? http://www.network54.com/Forum/5829

  • Unix shell: Environment variable works for file system but not for ASM path Update:10-11

    We would like to switch from file system to ASM for data files of Oracle tablespaces. For the path of the data files, we have so far used environment variables, e.g., CREATE TABLESPACE BMA DATAFILE '${ORACLE_DB_DATA}/bma.dbf' SIZE 2M AUTOEXTEND ON; T

  • Substituion Variables in Rules File as data source Update:10-11

    Hey all, This is a continuation of a previous post of mine. I have set some substitution variables to be all apps, all dbs, but when I got into the Rules File-File-Open SQL, it doesn't give me any substitution variables to select (greyed out), I have

  • Environment variable for icon files Update:11-30

    Does anyone know what's the name of the environment variable where Forms 6.0 lookup the icon files ? I instaled Forms 6.0 and I can't do that my buttons has the repective icon without include the path of the icon file. Marcial Bermudez Sysde nullTry

  • How to pass environment variables in Host file Update:11-30

    Hi Gurus, I'm having a requirement where I need to send my report output file as an attachment to customer. I achieved this by using host program and connecting to db server by using ftp. I am placing my output file in db server. From there onwards b

  • Environment Variables for Linux Update:11-30

    Hi All I am trying to set the Environement Variables on RHEL 5.2(64 Bit) for SM 7.0 Installation - I have installed the RPM "IBMJava2-AMD64-142-SDK-1.4.2-11.0.x86_64.rpm" - I have set the Environment Variable in .bash_profile file as below: expo

  • Substitution variable is not visible at Data Prep editor-creating rule file Update:10-11

    Hi, We are working on Essbase 9.3.1, Oracle as a database source for loading the data into Essbase. We have create a substitution variable at "server level" to use it in rule file as a DSN for data source. But this substitution variable is not v

  • Add firewall rule with custom environment variable in program path Update:11-30

    Hi, We want to create a firewall rule for a program which is placed in folder which changes sometimes. I know you can add a firewall with the ProgramFiles environment variable like this: netsh advfirewall firewall add rule name="Test Firewall rule&qu

  • Open module for managing property file and environment variables Update:10-11

    Looking for an open module for managing property files and environment variables (like CLASSPATH) set in a shell script. For handeling properties (preserving comments, supporting includes, appending new entries, and more) I have looked at SuperProper