top of page
Typ
Kategorie
110 Ergebnisse gefunden für „“
- is it possible t9 do incremental refresh in power bi with monthly snapshot data ?In Ask Questions·October 14, 2023Hi Hari, is it possible t9 do incremental refresh in power bi with monthly snapshot data ? I have history table that has snapshot data of each month, form this table , I want yo make the earliest month as a base table and the remaining month to be incremental refreshed? How can I achieve this ?0111
- help me to making Purchases Requisition and Purchase Order in SAP. Today I bought server access but I am unable to make PR and POIn Ask Questions·October 19, 2023help me to making Purchases Requisition and Purchase Order in SAP. Today I bought server access but I am unable to make PR and PO012
- How to increase the intelligence of interaction between a chatbot with an llm model through the processing of information from pdf documentsIn Ask Questions·September 29, 2023I am working on a chatbot connected to the OpenAI API that is responsible for answering questions related to documents that have previously been processed and finally saved in a vector database. The process that the PDF documents have followed consists of dividing the entire document into chunks and finally vectorizing them and saving them to a vector database that also connects to the interface where the user asks about the information of said document. I am also using python for the web interface and langchain as the framework to connect to the OpenAI APIs. However, when a user asks a question on the interface they sometimes get confused and give a very similar answer. This is because the PDF document has subtopics and among them some concepts are similar. So the question the user asks must be very specific. But what happens if the user doesn't know the topic and starts asking general questions? you will get wrong answers (Although for the model they will be fine) So now I want to improve the quality of my chatbot's responses. I want him to be smarter. I am thinking that the PDF document should be pre-treated, organized or divided into each subtopic. So that it is saved in an orderly manner in the vector database. Or maybe another tool is what I should modify? like python code. Some of you have had the same problem of poor quality answers due to many overlaps in various sections of the PDF document, and would like better quality and specific answers. Maybe you can comment and share a solution to this problem. I appreciate it very much.012
- Hi sir,I have today count measure Yesterday count measureIn Ask Questions·October 26, 2023Hi sir,I have today count measure Yesterday count measure Last week same day count measure How can we show today vs yesterday Today vs yesterday vs last week same day Today vs last week same day I'n line chart I tried to create switch measure But it accepts one value to one measure Any inputs on this pls018
- I need some help on a dynamic measure header display based on slicer selections.In Ask Questions·October 19, 2023I need some help on a dynamic measure header display based on slicer selections. Currently, my measure header is as follows by default (without slicer selection): Total Sales Total Cost Total GP But when my slicer of subsidiary is selected (for example ABC or XYZ), i need to measure header to change accordingly to below, depending on single selection. If multiple selections then default header applies. Sales for ABC Cost for ABC GP for ABC or Sales for XYZ Cost for XYZ GP for XYZ I have seem a few number of tutorials but mostly are dealing with dynamic column headers and I have no idea how to apply to measures. Bookmarks will not help as well since it might reverse selections of other slicers. Many thanks in advance! Cheers! Regards Shao014
- Can you please tell what is the difference between Paginated report visual in power bi visual pane and Paginated reports build through ..In Ask Questions·October 19, 2023Can you please tell what is the difference between Paginated report visual in power bi visual pane and Paginated reports build through report builder?014
- how to get this ' floor(weekend (today())))' in DAXIn Ask Questions·September 29, 2023how to get this ' floor(weekend (today())))' in DAX019
- Here's a more detailed set of notes based on the Erwin Data Modeler tutorial overview:In Tech Talk·September 19, 2023Erwin Data Modeler Tutorial Notes: 1. Introduction to Erwin: • Definition: Erwin Data Modeler is a tool designed for data modeling, allowing users to visually design, generate, and manage databases. • Model Types: Supports various types of data models including logical, physical, and conceptual. 2. Getting Started: • Installation: • Ensure system requirements are met. • Follow installation guidelines and enter the license key when prompted. • User Interface: • Model Explorer: Displays the structure of your model. • Diagram Window: Visual representation of your data model. • Properties Window: View and edit properties of selected objects. 3. Creating a New Model: • Steps: • Go to File > New. • Select the type of model. • For physical models, specify the target database (e.g., Oracle, SQL Server). • Save Regularly: Use File > Save to save your progress. 4. Logical Data Modeling: • Entities: • Represent data objects or things you want to track information about. • Add attributes to entities to represent data elements or fields. • Relationships: • Define connections between entities. • Set cardinality (e.g., one-to-many). • Generalization & Specialization: • Represent "is-a" relationships. • Useful for capturing inheritance in data models. 5. Physical Data Modeling: • Tables: • Equivalent to entities in logical modeling but tailored to a specific DBMS. • Add columns to represent data fields. • Indexes: • Structures to improve query performance. • Can be unique or non-unique. • Keys: • Primary Key (PK): Uniquely identifies a record. • Foreign Key (FK): Links tables together. 6. Forward & Reverse Engineering: • Forward Engineering: • Convert logical models to physical models. • Generate SQL scripts to create the database. • Reverse Engineering: • Extract structures from an existing database to create a model. • Useful for documentation or to understand legacy systems. 7. Model Validation: • Purpose: Ensure the model is consistent and free from errors. • Process: • Use Erwin's built-in validation tool. • Review and address any issues or warnings. 8. Generating Reports: • Benefits: Documentation, stakeholder communication, and review. • Formats: Erwin can generate reports in HTML, RTF, XML, etc. • Customization: Tailor reports to include specific details. 9. Model Comparisons & Merging: • Comparison: Identify differences between models or between a model and a database. • Merging: Integrate changes from one model into another. 10. Collaboration & Version Control: • Team-Based Modeling: Multiple users can work on a model simultaneously. • Version Control: Track changes, maintain versions, and manage model history. 11. Advanced Features: • Naming Standards: Ensure consistency in naming conventions. • Macro Language: Automate repetitive tasks. • User-Defined Properties (UDPs): Add custom properties to model objects.0115
- MySQL query - all combinations without duplicates or reverse order duplicatesIn Ask Questions·September 29, 2023I have a query that returns all possible combinations from 5 columns. The problem is I want to remove duplicates (Car | Car) and reserve order duplicates (Truck | Car) if (Car | Truck) already exists. I’ve played around with DISTINCT, but haven’t had any luck. Sample Data: wdt_id|column1|column2|column3|column4|column5 1|Car|Car|''|Cat|'' 2|Truck|Truck|''|Dog|'' 3|Plane|Plane|''|Bird|'' SELECT item1, item2, item3, item4, item5 ,concat_ws('',NULLIF(item1,''),NULLIF(item2,''),NULLIF(item3,''),NULLIF(item4,''),NULLIF(item5,'')) as combination FROM ( SELECT column1 AS item1 FROM sample_data ) AS t1 CROSS JOIN ( SELECT column2 AS item2 FROM sample_data ) AS t2 CROSS JOIN ( SELECT column3 AS item3 FROM sample_data ) AS t3 CROSS JOIN ( SELECT column4 AS item4 FROM sample_data ) AS t4 CROSS JOIN ( SELECT column5 AS item5 FROM sample_data ) AS t5 GROUP BY item1, item2, item3, item4, item5 ,concat_ws('',IFNULL(item1,''),IFNULL(item2,''),IFNULL(item3,''),IFNULL(item4,''),IFNULL(item5,''))013
- Are the Ciphers ECDHE-RSA-AES128-SHA256 and ECDHE-RSA-AES256-SHA384 strong?In Ask Questions·September 29, 2023ELBSecurityPolicy-TLS13-1-2-2021-06 Once this policy is updated the server has listed below Ciphers which are supported. Preferred TLSv1.3 128 bits TLS_AES_128_GCM_SHA256 Curve 25519 DHE 253 Accepted TLSv1.3 256 bits TLS_AES_256_GCM_SHA384 Curve 25519 DHE 253 Accepted TLSv1.3 256 bits TLS_CHACHA20_POLY1305_SHA256 Curve 25519 DHE 253 Preferred TLSv1.2 128 bits ECDHE-RSA-AES128-GCM-SHA256 Curve 25519 DHE 253 Accepted TLSv1.2 128 bits ECDHE-RSA-AES128-SHA256 Curve 25519 DHE 253 Accepted TLSv1.2 256 bits ECDHE-RSA-AES256-GCM-SHA384 Curve 25519 DHE 253 Accepted TLSv1.2 256 bits ECDHE-RSA-AES256-SHA384 Curve 25519 DHE 253 Are these Ciphers strong or safe? As per my understanding from web, the GCM ones are strong Ciphers. However when I checked for others, say "ECDHE-RSA-AES128-SHA256" the search results only show "ECDHE_RSA_WITH_AES_128_CBC_SHA256". Looks like this one has vulnerabilities (Beast attack). Are these both same? Is it ok to allow "ECDHE-RSA-AES128-SHA256" and "ECDHE-RSA-AES256-SHA384" Please advise.013
- How to configure import mode for PBIRS report?In Ask Questions·September 29, 2023How to configure import mode for PBIRS report? Does power bi report server paginated report (made via report builder) support import mode?014
- C Macro with a function errors out: expression cannot be used as a functionIn Ask Questions·September 29, 2023Inspired from this,(https://stackoverflow.com/questions/8487986/file-macro-shows-full-path) I am trying to write my Macro that uses a function inside, and fail: #include // Define a helper macro to get the file name from __FILE__ #define FILENAME_ONLY(file) (strrchr(file, '/') ? strrchr(file, '/') + 1 : file) // Use the helper macro to create MYFILENAME #define MYFILENAME FILENAME_ONLY(__FILE__) // Create __MYFILE__ macro #define __MYFILE__ "[" MYFILENAME "]" #include int main() { printf("%s\n", __MYFILE__); return 0; } I get: main.cpp:4:80: error: expression cannot be used as a function #define FILENAME_ONLY(file) (strrchr(file, '/') ? strrchr(file, '/') + 1 : file) What am I missing please?013
bottom of page