Macro functions - undocumented feature in Report Studio

Tamas Simon said: Did you know you can use macro functions in Report Studio?How about sharing some ideas in this thread about what they're good for?For example you can use a value prompt (list, or combo) to return a MUN in its ``use value'' and then use it in a dimensional report.If you have a cross ...

Calling Word Macro functions from C++

Can any one please tell me if we can call Word macro functions from with in C++ code. I have a function fucn() within a word macro called WMacro. Now would it be possible to call func() from C++ code.Any advice would be appreciated.Mallesh ...

Calling Word Macro functions from C++

Can any one please tell me if we can call Word macro functions from with in C++ code. I have a function fucn() within a word macro called WMacro. Now would it be possible to call func() from C++ code.Any advice would be appreciated.Mallesh ...

macro functions ???

What are macro functions (function-like macros)?? ...

Cognos 7.3.3 Scheduler recurring macro throws error and won't refresh cube

please help this is very urgent!!I have an environment (Windows 2003 R2 Server std x64 SP2 and Cognos 7.3 MR3) that was perfectly running Cognos scheduler with a OS batch admin account (also is in admin group in Cognos AM) that refreshed PP Cubes using Cognos Macro scripts each month. Lately I start ...

Trouble displaying Access query results from Excel macro

I have an Access macro that runs a query. This macro functions fine in Access. I would like to run it in an Excel macro (I've very little vba knowledge and clipped what I could online). The macro I have in Excel runs my Access macro/query- it requests my parameters, but then no results are displayed ...

Trouble displaying access table in excel macro

I have an Access macro that runs a query. This macro functions fine in Access. I would like to run it in an Excel macro (I've very little vba knowledge and clipped what I could online). The macro I have in Excel consists of a userform that runs my Access macro/query when the user clicks a button- it ...

Having trouble understanding marco functions

forum. I'm new to c programming. I have been reading source files from my smt32 firmware and I came across this code. In one of my books I read that you can have macro functions. Is this function testing whether I2C1 and I2C2 is enabled? #define IS_I2C_ALL_PERIPH(PERIPH) (((PERIPH) == I2C1) \|| ((PE ...

Oracle do macro function using a button?

Is there a way to use a button to do macro functions?I want to tell it to go to the brower's file, to let's say, print or properties.Is this possible? ...

Error when using CSVIdentityNameList ( ) in Macro

I'm getting an error when trying to use various macro functions. I'm trying to apply a filter depending on which group the User is in, but I cannot even return the basic data telling me which groups I'm in. I've tried various functions, such as;CSVIdentityNameList ( ) CAMIDList ( ) CAMIDListForType ...

how to show what database server report is connecting to?

Is there a way to show what database server a report is connecting to? Is there a cognos macro/function? Or maybe add a query subject in framework that returns @@servername?How about showing which data source the report is using too?We change the connection strings often in the development environme ...

Manipulating TM1 9.5 Sandboxes in Excel VBA

Is it possible (either through undocumented API calls or TM1 macro functions) to change which sandbox an excel worksheet reads/writes to?I am creating a data_input_template in Excel 2007, and I would like to globally change/set the sandbox the users will write to when they open the workbook (in the ...

Manipulating TM1 9.5 Sandboxes in Excel VBA

Is it possible (either through undocumented API calls or TM1 macro functions) to change which sandbox an excel worksheet reads/writes to?I am creating a data_input_template in Excel 2007, and I would like to globally change/set the sandbox the users will write to when they open the workbook (in the ...

Access 95 to XP Access and Access 95/WinXP problems?

I have a data base that has been developed over the years on Access 95. It has about 2000 queries and 3000 macros. The only code it has is on the OnClick on labels and the code in each case opens Word docs that have queries linked to the docs and it inserts Access field data into Bookmarks, prints t ...

Ubuntu Multi-page tiff creation

I have 4500 tiff images, each <400 kb in size, that I need to merge into one multi-page tiff file. So I came across ImageJ. Looked promising at first but ended up producing an error message: java.lang.OutOfMemoryError: Java heap spaceat ij.io.ImageReader.read8bitImage(ImageReader.java:4 3)at ij.i ...

Ubuntu Keybord and Mouse fail after 9.04 upgrade

Hello, I'm a new user (a few weeks) and so far I have loved Ubuntu... However, I just upgraded from 8.10 to 9.04 and my wireless optical keyboard and mouse stopped working after the restart. I have searched the forums for hours and all I can find are issues with macro functions and blue tooth but no ...

pointer to map, switch(std::string)...

i'm writing a small program that outputs the input's decoded numbersie, hello = 104, 101, 108, 108, 111but you can also typein things like "[restart]", ["decode"], ["encode]","[whitespace]" and stuff like thatanyway, this is more a trivial program so i'm tryin ...

Ubuntu No sound on Laptop

I've installed Ubuntu 8.10 on my laptop recently,But there is no sound output! and I can not hear anything!My Laptop details:Gateway, Pentium4 and 1.8 dual processorHere are some details which might be helpful:asoundconf list:Names of available sound cards:I82801DBICH4asoundconf:Usage:asoundconf is- ...

Ubuntu Major sound issues, possibly self-inflicted

I have been using Ubuntu for about half a year now, and have had many a sound/video problem in the past. However, most were fixable through some simple menu or option changing. But now, through a cruel twist of fate (probably WINE), I have f****d up my sound, and i apologize, but there is no better ...

How to publish analyst macro to cognos connection

Dannie Reid said: Hi ALL,We will need to publish the analyst macros in cognos connection.Does anybody have any idea on how do I achieve this.I know that contributor macros can be published into congnos connection.So, one way of analyst macro to be made available in cognos connection is to create a c ...

test Cognos functions

My enterprise is planning to buy a BI tool to create Dashboards, we are testing several tools to see if their functions match with our requirements.I know that Cognos is a powerful tool but before buying it I would like to be sure the tool can do everything I want. The demo gave me some information ...

Pass parameters to teradata macro from Cognos 8.4 Prompt Page

HiWe need to pass 3 parameters(2 from the prompt page and the third is cognos loginID with which the current user has loggeod on).When the user clicks the Finish Button, These 3 parameters should get passed to a teradata macro(The Macro should get triggered). NOTE: The macro consists of insert state ...

Calling Advanced Math Functions in Cognos Data Manager

I have been attempting to calculate advanced math functions (such as acos and atan) in Cognos Data Manager. These functions exist in the Microsoft dll mscorlib.dll. However, I cannot call them through an external function call in Cognos DM. DM can see the dll but not the functions. I do not know if ...

Finding a category in cognos transformer using Macro

->By using macro, how can we find a category. ->how can we update Context Level,Context Offset, Target Level and Target Offset values in cognos transformer cube model. ...

Import COGNOS Series 7 macro into VB

Dirk Frischemeyer said: Hello Guys, I have a COGNOS Script Macro, which runs fine. Now I have to import it to VB.But I'am new in VB. I knew, I have to declare a *.dll or something like that. Does anyone has a code sample? ...

Supported Functions using Cognos

We are using various Cognos Products (Impromptu, Framework Manager, Transformer) on top of a DB2/400 Database using Client Access ODBC to connect. We are experiencing different issues depending on the version and build release of the Client Access and various Cognos softwares. This is mostly related ...

macro that defines functions

does anyone know if I can write a macro that takes a number as argument and according to that number declares a variable number of functions ?ex:DEFINE_FUNC( 4 );is replaced withvoid func_1();void func_2();void func_3();void func_4();thx ...

Macro for getting public functions

Can you please give me a Macro(.dsm), which gives only 'public' functions in a header file.for eg:class Test{public:Test();Hello();private:TestMe();};When I run the macrom it has to give me Test() and Hello(). ...

#define macro vs Tiny functions

I just Read #define macros use instead of tiny functions...How i rewrite the following tiny fn:by a #define macrostatic long Multiply(long m,long n){return ( ((long long) m) * ((long long) n) ) >> 32; }Plz comment.... ...

macro that defines functions

does anyone know if I can write a macro that takes a number as argument and according to that number declares a variable number of functions ?ex:DEFINE_FUNC( 4 );is replaced withvoid func_1();void func_2();void func_3();void func_4();thx ...

COGNOS Analysis for Excel (CAFE) - Excel VBA Macro does not wait for CAFE

SuKii Lau said: Hi there,A colleague of mine has created an excel report template using CAFE to retrieve data based on various dimensions. She has also written a macro to generate various excel reports everytime a particular member of a dimension is changed. The macro is intended to refresh all data ...

Passing parameters to a teradata macro from Cognos 8.4 Prompt Page

We are having 2 Macros which was build in Teradata. First macro will consist of all the select statment with 2 prompt values.Values are Start_date,end_date.The Prompt page was built on the 2 promps.When user select the Prompts of Start_date and End_Date and click the finish button,the start_date and ...

Extract Server name from Cognos FM(8.3)

We need to extract the Servername thru which the Cognos Requests are processed from the Cognos 8.3 Framework Manager to make changes accordingly from the model file.We tried using macro function #sq($machine)#,but it returns null.Can someone help me on this with an approach or correct me in using th ...

logf macro in math.h

#include <math.h>void SomeFunc(){float_t winlen = 4;float_t rayparam = 48./512. * winlen;float dfwvnorm = expf ( (logf(2.0)/rayparam) * (winlen+2) ); // <-- compiler error if I use 'logf' but not if I use 'log'}I'm trying to build libaubio using VC++8. There's a function that essentially bo ...

is there a way to create a DLL without use __declspec dllexport at each functions ?

any1 know if there is a way to create a dll project without use __declspec dllimport/dllexport at each function ?what i am actually need here is, convert a static lib project into a dll project. and this project contains couple hundred files. the only way that i am aware of to make a dll is by put _ ...

first time working with overloaded functions....

ok,as the title says this is my first time working with overloaded functions. i cant for anything figure out where im doing this wrong. but everytime i compile i get the same errors! heres the code, followed by the errors. thanks for any and all help!// Overloaded functions.cpp : Defines the entry p ...

Undefined references to functions

I am trying to build a executable file with libraries which arealready built with gcc (version 2.95.3-6 ) on cygwin environment.Cygwin is set up on Windows. Now I need to generate a executable fileon Linux using gcc compiler itself. For this I am using a makefilewhich is provided here for clear info ...

how to run Excel Macro from Report Studio

Genti Hila said: I need to export a report to Excel from Report Studio (8.2) but I have some formating that Cognos told me cannot be done from BI. I need to run a macro in order to achieve the desired results. How can I run the macro at the time of exporting the report.Any idea is very much apprecia ...

job in cognos connection

Giulio Sacchi said: how to allow users to run macro in cognos connection?where must be set the users rights? ...

Not able to Use the Oracle functions

Phyllis Tsu said: Hi Gurus,I am migrating my catalog from Impromptu 7.4 to Cognos 8.2. I didnt get any errors during the migration. But when I ran a few of the reports it gave me the below error. I did a little research on KB too and found out that some how it is not supporting this Oracle function. ...

MySQL datasource and Cognos 8.3 - database function issue

Csonka Peter said: Does anybody have experience with MySQL datasource and Cognos 8?I am unable to use the MySQL database functions. The simple cast, case.. not workingcast(create_date as date)for test I tried with one table direct from the database, 2column, no join, nothing.RQP-DEF-0177 An error oc ...

Incremental publish of cognos analyst cube

Dannie Reid said: Hi ALL,We will need to publish the analyst macros in cognos connection.Does anybody have any idea on how do I achieve this.I know that contributor macros can be published into congnos connection.So, one way of analyst macro to be made available in cognos connection is to create a c ...

Not able to run publish macro/ elist export macro (analyst) from contributor

Dannie Reid said: Hi ALL,We have four different cognos macros which we are not able to run through contributor. The common features these macros has are 1) It exports an elist to a csv file in the file system 2) It publishes cubes to SQL server tableAny macros wothout these features is running fine ...

Cognos 8.3 and Windows Vista

said: I have installed Cognos 8.3 BI Server on a Windows Vista PC and it works fine except for the Admin functions.When I try to access Cognos Administration from Connection, I get the message below.Any suggestions?<table><tr><td>DashboardException</td></tr><tr> ...

Question about Functions

i am in my first C++ class and have already written two simple C++ programs. Im working on another using functions. I have to write 3 functions to calculate the area, cost, and retail price for wooden boxes and a main function to have the user input information for the program and output the results ...

Using a DLL to add functions to my project?

First I am newbie and I am trying to add functions to my project from a DLL that I already have following is the codeHINSTANCE hDLL;typedef INT (CALLBACK *INITCAM)( INT );typedef INT (CALLBACK *PANTILTCAM)( INT, INT );typedef INT (CALLBACK *CENTERCAM)();typedef INT (CALLBACK *FREECAM)();INITCAM Init ...

NoClassDefFoundError Cognos Administration Web

I am working on my first install of Cognos 8. I am setting up a distributed installation with the Content Manager, Application Tier, Data Source(Oracle10g) and Gateway(Apache2.2.10) on 4 separate systems(z/Linux64(SLES11).All servers are up and running. I am trying to navigate around and learn the i ...

How to query the Active Directory attributes from Cognos FM or Report Studi

These are the values of the #CSVIdentityNameList()# session parameter in CognosHow can I pick a specific value using Cognos functions from the below list;'All Authenticated Users', 'Authors', 'Cognos Users', 'Consumers', 'DCTEST', 'Directory Administrators', 'Everyone', 'HO', 'LPOP-ClubGM', 'LPOP-Re ...

Cognos HTML Engine

I am trying to create a cognos report which has AJAX functionality. This report will call another report in background and show me the data. This backgroud report has a list control only. But somtimes the background report doesnt return complete HTML page for the report all I see is JS functions of ...

Cognos 8.4 and SQL Function errors

After upgrading to Cognos 8.4 from 8.3 we have one report that uses SQL functions (right, ltrim and str) that does not run. The error is: UDA-SQL-0219 The function "right" is being used for local processing but is not available as a built-in function, or at least one of its parameters is not support ...