Home > > BI 7 : filtered columns

BI 7 : filtered columns

Hello Experts,
I am using query designer BI 7 version,
Created a query and have used 2 filters, My question on exection in web, the filltered values come in the corner and no longer the columns are seen in the structure..
Is there a setting to retain them in output also... show filtered structure...???  where it is!!!
Hi  Bijal,
      you can take those  filtered  info objects into   Rows also... then you will get those  those    info objetcs are displayed in columns in the output..
    for  example you  want to filter  Material from  100 to 500 .. then you can put 0Material  in ROWS and as well as filters also.. but in filter you need to mention the condition..
   then you will get  0Materail(but only from 100 to 500 )  also in the output .. along with the  corresponding values..
Read the other 3 answers
Hello... When I use the FormsCentral "view responses" tab's excel spreadsheet report, I can't seem to SUBTOTAL any columns once they have been filtered! I only see an option for adding SUM in the last row, but it calculates all of the filtered a
Dear All, I'm using Oracle Analysis. I have two column, each one have different formula. My Formula based on filter. Column1 FILTER("DW"."SUM_PLAN_MONTH_AMOUNT" USING ("DW"."PLAN_YEAR" BETWEEN YEAR(DATE'@{P_BEGIN_DA
I can't seem to subtotal any columns if they have been filtered.  If you use the SUM function, it still calculates all of the chart's rows.  How do I only add up the filtered set? Thank you! -ChrisP.S. I'm using FormsCentral... and it doesn't offer S
Hello,      Good day !      I am working with CR 2008 sp3 Fix 3.3 and ASP.NET 2.0 .      I have a tabular report  with n  number of coulmns.(for ex:6 columns)      I would like to know how to apply filter on these colums?      I saw the presentation
Hi all, i have a file that contains data such as 111 Test ####### #testme juio# ### as you can see, the data is fix length and separate by spaces some field will have value such as ### and some column will contain alpha numeric with some # such as ju
Does Robohelp 9 have the ability to filter colums and rows just like Microsoft Excel?   I created a table in Robohelp with 6 columns and 30rows, is this something the software can do? Thanks WendyI don't know of any help authoring tool that does that
Hi, I want to be able to select a few columns depending on a key. for instance, if my key is 'FA' then I want my FA columns to be the ones returned and not PG even though PG's columns are also declared. Here's the idea: table1 id  key  val FA  1  5th
Hi everyone, The following code fragment apparently creates a dataset from an xml file. The first line creates the dsStates dataset from an xml file called states.xm. The second line seems to be pulling in the list of cities into the dsCities dataset
Hi everyone, I need some help with filtering a JTable. Basically I have five columns in my table and five text fields for Username, First Name, Last Name, Address and Phone Number. What I need to do is have each text field filter the column it is ass
When saving a document library as a template, any configured metadata navigation and key filters columns are lost. Has anyone else experienced this issue or know a viable workaround? Can anyone shed some light on why these settings are not saved with
Hi all, Thanks in advance , Below is the query SELECT * FROM (SELECT MitarbeiterListe.IDMITARBEITERLISTE, MITARBEITERLISTE.JAHR , MITARBEITERLISTE.mitarbeiter , FIRMA.FIRMA , Abteilung.Abteilung , MitarbeiterStatus.mitarbeiterstatus , MitarbeiterList
Hi, I have an af:table with filterable columns and some of these columns are based on Timestamp VO attributes. When I enter a date filter - either manually or from the associated date picker, the filter is applied correctly using a date format of dd/
Hi Experts,    I save an ALV layout with some filtered columns. Now I would like to take the columns through program giving the variant name as input. I get variant info from LTDX table, but no the columns of ALV. Could u please tell me any FM to fin
I have a table (af:table) with a filterable column. How could I iterate through the rows after the filter was applied? Thanks in advance jleon (JDeveloper you tried to get the iterator in the bean method and iterate over it?         B
I have a table with filterable columns and want to add a popup hint to the filter input to help users with search conditions, similar to how a hint on the date format is automatically added when filtering by date on a column. I thought the shortDesc
Hi there, I've noticed that when I run a query in Answers, if the query has a filter which is not in the displayed columns, the query runs very slowly. However, if I run the same query WITH the filtering column in the displayed columns, the query wil
It looks like datasource to rowsource map filters are and'ed. Say I'm loading records with a plant location field. Then creating two filters, 'Plant equals US' and 'Plant equals Canada' will result in no records loaded. Is there a way to cause filter
Is there a way to use different filters in one Answers query? For example, I want to place two tables onto Compound layout view. The first table is prepared using one filter, and the second - using another filter. PS. I know that I can use two differ
I have columns with null values, but in filter option I do not have the option (Empty) as standard in SharePoint Environment is.  protected void Page_Load(object sender, EventArgs e)             FillGrid();         private void FillGrid()