No announcements
Found 3703672 threads
-
0 VotesGet data based on time stamp from a table with millions of rows
The task is to get the count of records per ID based on time stamp.Answered | 7 Replies | 956 Views | Created by app087 - Wednesday, February 3, 2016 9:20 PM | Last reply by app087 - Thursday, February 4, 2016 3:58 PM
-
0 Votes
filter the data from a table to a report
To add a filter, you must specify one or more filter equations.Answered | 6 Replies | 4448 Views | Created by justin_rock - Monday, October 18, 2010 9:20 PM | Last reply by Challen Fu - Thursday, October 21, 2010 8:01 AM -
0 Votes
Filter cube data from table
In the DSV of the cubes , replace the actual table with named query where you can write your own query for that dimension and filter the data.Answered | 2 Replies | 3591 Views | Created by Mani Ayyanar - Friday, December 30, 2011 6:30 AM | Last reply by Sorna Kumar Muthuraj - Friday, December 30, 2011 2:24 PM -
3 Votes
Dynamically filter data that hit all selected filter, or either of the selected filters
While TableAll is a different filter from Eall, I have no idea why you'd add this step.Answered | 17 Replies | 1304 Views | Created by AvivZa - Sunday, April 21, 2019 1:25 PM | Last reply by Alexei Stoyanovsky - Friday, May 3, 2019 4:14 PM -
2 Votes
How to filter results based on multiple selections
I need to be able to select multiple tags in the linking table (issueTag) which has the issueID and TagID as the keys, and use the selected items to filter the ...Answered | 3 Replies | 2316 Views | Created by Quantumfreeze - Tuesday, March 8, 2011 1:58 PM | Last reply by Quantumfreeze - Tuesday, March 8, 2011 9:24 PM -
0 Votes
Filtering based on time
You can filter on time, but you have convert the values to FileTime.Answered | 1 Replies | 8047 Views | Created by Nicholas Vasile - Thursday, July 8, 2010 5:34 PM | Last reply by Paul E Long - Friday, July 9, 2010 2:19 PM -
0 Votes
using a relational based table as a filter in a cube based report
These selected values can then be used for filtering Cube data.Answered | 7 Replies | 3729 Views | Created by db042188 - Wednesday, December 7, 2011 8:38 PM | Last reply by db042188 - Thursday, December 22, 2011 7:48 PM -
1 Votes
get Data from one table that is not on second table
SELECT firstname ,lastname ,[money] FROM table1 a WHERE NOT EXISTS ( SELECT 1 FROM table2 WHERE ...Answered | 1 Replies | 758 Views | Created by Gilberto H_ - Tuesday, March 12, 2013 3:17 PM | Last reply by Barry Marshall - Tuesday, March 12, 2013 3:28 PM -
0 Votes
Show data from multi tables based on combo box selection
[DDate] FROM Mcve1 union all SELECT Mcve.Answered | 5 Replies | 324 Views | Created by Hadi1989 - Tuesday, March 1, 2016 6:03 AM | Last reply by Edward8520 - Tuesday, March 8, 2016 9:02 AM -
0 Votes
How to change filters based on selection
Hello, you need cascading parameter see step by step ...Answered | 2 Replies | 1138 Views | Created by VandanaReddy - Friday, January 18, 2013 7:00 AM | Last reply by Sanjeewan Kumar - Friday, January 18, 2013 7:53 AM -
0 Votes
Multi same Tables ?
Hi, No , I search, if it s possible, how filter with "OR" on 4 dimensions from a disctonnected table.Answered | 11 Replies | 767 Views | Created by Cobra776 - Tuesday, December 5, 2017 1:33 PM | Last reply by Cobra776 - Monday, December 18, 2017 4:49 PM -
1 Votes
Select Statement - Filter results based on rows in another table
select * from Table1 T where not exists (select 1 from Table2 T2 where T2.Data_Col1 = T.Data_Col1 and T2.Data_Col2 ...Answered | 2 Replies | 5950 Views | Created by Routaran - Wednesday, March 9, 2011 5:10 PM | Last reply by Routaran - Wednesday, March 9, 2011 6:27 PM -
0 Votes
Getting input from several tables into one table
I think based on your idea I'll get what I wanted.Answered | 4 Replies | 948 Views | Created by Purclot - Monday, March 9, 2015 9:47 AM | Last reply by Purclot - Tuesday, March 10, 2015 10:09 AM -
0 Votes
Visual Web Part, to get data from SQL Table, filter based on the logged on user...!
Not aware how to do with BCS as have not tried it but what I can suggest is that you should write a sql query to fetch the data from the database based upon the logged in ...Answered | 3 Replies | 5178 Views | Created by Barakat Al-Abri - Friday, December 30, 2011 1:53 PM | Last reply by Tobias Zimmergren - Sunday, January 8, 2012 12:18 PM -
0 Votes
Need to copy data from one table to another based upon SiteiD
Seems you need an update: UPDATE Table1 SET SystemName = (SELECT B.SystemName FROM Table2 AS B WHERE B.SiteID ...Answered | 5 Replies | 3751 Views | Created by jilan3109 - Friday, July 10, 2009 11:30 PM | Last reply by Plamen Ratchev - Saturday, July 11, 2009 5:02 PM -
1 Votes
Pivot Table Multi Select Filter Value Performance
As the UI interface performs just as fast with a single filter as it does with a multi select filter (sub second in my case (against 250K of data)), but ...Answered | 5 Replies | 1114 Views | Created by AuroraMan1 - Thursday, November 5, 2015 7:12 PM | Last reply by Edward8520 - Friday, March 18, 2016 8:25 AM -
0 Votes
Select data from Table B based on info from Table A
Hi Paul Fallows, You may use script below to get the output as well.Answered | 3 Replies | 582 Views | Created by Paul Fallows - Wednesday, September 14, 2016 9:24 PM | Last reply by Sam Zha - Thursday, September 15, 2016 7:24 AM -
2 Votes
How to filter data in one list based on the data in another list sharepoint portal using two filter criteria
This is what i need: I wish to filter my Child List based on Start Date and End Date specified in To master List.Answered | 3 Replies | 22575 Views | Created by Selkrishna - Tuesday, September 27, 2011 12:04 PM | Last reply by NiravP - Tuesday, May 28, 2013 2:49 AM -
1 Votes
Get sales Amount value from one table base on max date
Based on your example-table this calculated measure should work: MyLastValue:=CALCULATE( SUM('Table 1'[Total ...Answered | 2 Replies | 1217 Views | Created by Praveen.C - Wednesday, April 2, 2014 5:11 PM | Last reply by Gerhard Brueckl - Tuesday, April 22, 2014 12:33 PM -
0 Votes
Filter Fact Table based on an Unrelated Dimension Table
A compete brand may compete against multiple base brands'.Answered | 1 Replies | 622 Views | Created by Sanjay Shah Prosys - Monday, June 27, 2016 6:25 AM | Last reply by Darren Gosbell - Monday, June 27, 2016 7:17 AM - Items 1 to 20 of 3703672 Next ›
No announcements
