Search results for query: *

Synchronising user group in Cognos namespace from a BW hierarchy Hi, the datsource is SAP BW, I would like to create in FM some security filter based on a sales rep and their customer hierarchy provided in SAP BW infocubes. in order to do so, I would need: 1. import and synchronise group...

I found a bug in reportnet's MDX Code Generator: when you use an agregate function such as count/sum etc, the MDX statement does not contain anymore all the filtering items you use in you query (datasource being SAP BW). a cognos support case has been opened in my country under the number...

Hi, Due a bunch of limitations on business date/time fonction on a SAP BW datasource under reportnet(it is an olap and not rdbms datasources...), we would like to pass all filter values via some parameter/prompt.(we tried several alternative before considering doing this via SDK, such as...

Hi shwetabh, have you tried it already, eg do a calculation on query items within a layout calculation? for me this does not work, and when I look at the definition of a layout calculation, it sounds to work on reports functions such date of report etc but not on query items....even if in the...

hi, under RS studio, assume I have two queries (with 2 different datasources), they return each one a single value: result 1 (put in cell 1 of the layout) and result 2 (put in another cell in my layout) Now, I would like to make a calcultation such as cell 1 minus cell 2. as said, the...

After several weeks, I come to the conclusion that due to MDX limitations on BW sidek the integration with BW is very restricted in terms of functions such as time/date, merging of queries in FM, calcultation in filter from FM etc.. basically, you shoud have all the filtering and any smart...

After several weeks, I come to the conclusion that due to MDX limitations on BW sidek the integration with BW is very restricted in terms of functions such as time/date, merging of queries in FM, calcultation in filter from FM etc.. basically, you shoud have all the filtering and any smart...

Hi all, There are lots of limitations of reportnet 1.1 MR2 with SAP BW datasources, for example you CANNOT use filtering statements on a BW datasource on business date/time functions: current_date, _first_of_month, _last_of_month etc... still I need to filter my BW queries as following...

I found the solution, here is the answer for each level of objects 1. At the table level: border-collapse:collapse;table-layout:fixed" 2. at table cell, you need to define a fix size with a padding at zero: padding:0px;width:3cm 3. at <list> box: border-collapse:collapse 4. finally for...

Hi, under report studio, In a table cell with a fix Width, I insert a one column list box. The list column width has also the same value as the parent cell. now when I run the report in pdf the list column does not fit exactly the parent table cell. I used padding and other margin, but with...

unarayan, did it worked for you as I have the same issue but could not make it work the way DoubleD proposed it in RS, thanks for your answer david

Hi, In report studio from reportnet, with datasources SAP BW, I would like to filter on business dates. I would like to have a filter on dates that belong to the current week, month or year. I tried many syntaxes in the filter editor but nothing works (datasource is BW and NOT an sql DB). has...

hey, has anyone already tried to do the following on FM for SAP BW infoqueries: I have 2 infoqueries with different key figures bu common dimensions/hierarchies, such as: 1. Infoquery Billing Key figures - Sales €uro Dimension - Time - Customers 2. Infoquery order Key figures - Order €uro...

hi, has someone already tried to modify the reportnet xsl stylesheets such as welcome.xsl in order to customize the user interface? I made some changes that are valid (parsing is ok) and no erreur after restart reboot of reportnet.... but the changes made in the xsl stylesheets are not taken...